0

System Global Area

Description: SGA in oracle Java/Oracle /C/C++Oracle
Number of Questions: 15
Created by:
Tags: SGA in oracle Java/Oracle /C/C++ Oracle
Attempted 0/15 Correct 0 Score 0

Which of the following background processes is responsible for routing requests from connected user processes to available shared server processes?

  1. Log writer

  2. Process monitor

  3. Dispatcher

  4. The stream pool

  5. Queue monitor


Correct Option: C
Explanation:

This background process is responsible for routing requests from connected user process to available shared server processes.

At specific times, all modified database buffers in the SGA are written to the datafiles by which of the following background processes?

  1. Process monitor

  2. Database writer

  3. Log writer

  4. Lock manager server

  5. Mounting the database


Correct Option: B
Explanation:

At specific times, all modified database buffers in the SGA are written to the datafiles by the database writer.

The information in which of the following files is used to recover the database from a media failure?

  1. Redo log file

  2. The parameter file

  3. The archive file

  4. Instance creation

  5. Abort


Correct Option: A
Explanation:

The information in a redo log file is used to recover the database from a media failure.

Which of the following memory components of the SGA contains modified blocks and clean or unchanged blocks?

  1. Registration

  2. The java pool

  3. The stream pool

  4. Session memory

  5. Database buffer cache


Correct Option: E
Explanation:

This memory component of the SGA contains modified blocks and clean or unchanged blocks.

A database that is divided into logical storage units is called :

  1. Recover

  2. Segments

  3. Views

  4. Tablespace

  5. Tables


Correct Option: D
Explanation:

A database is divided into logical storage units is called tablespace.

With real application, which of the following background processes instance can perform instance recovery for instances?

  1. Lock manager server

  2. Opening the database

  3. System monitor

  4. Process monitor

  5. Log writer


Correct Option: C
Explanation:

With real application, the system monitor process of one instance can perform instance recovery for instances.

The data of logical database structures such as tables and indexes are physically stored in which of the following files?

  1. Datafiles

  2. The archive file

  3. The parameter file

  4. Instance creation

  5. Read only


Correct Option: A
Explanation:

The data of logical database storage structures such as tables and indexes are physically stored in the datafiles.

Which of the following logical storage structures is a specific number of contiguous data blocks obtained in a single allocation?

  1. Password file

  2. Extent

  3. Segment

  4. View

  5. Table


Correct Option: B
Explanation:

This logical storage structure is a specific number of contiguous data blocks obtained in a single allocation.

The redo log entries stored in which of the following memory components of the SGA are written to an online redo log?

  1. Registration

  2. The java pool

  3. Stream pool

  4. Redo log buffer

  5. Session memory


Correct Option: D
Explanation:

The redo entries stored in the redo log buffer are written to an online redo log.

Which of the following background processes is responsible for signaling database writer at the check points and updating all the datafiles and control files of the database?

  1. Mounting the database

  2. Process monitor

  3. Checkpoint process

  4. Lock manager server

  5. Log writer


Correct Option: C
Explanation:

This background process is responsible for signaling database writer at the check points and updating all the datafiles,  and control files.

Which of the following memory components of the SGA provides large memory allocations for Oracle backup and restore operations?

  1. Large pool

  2. The stream pool

  3. The java pool

  4. Session memory

  5. Password file


Correct Option: A
Explanation:

This memory component of the SGA provides large memory allocations for Oracle backup and restore operations.

The entries such as the database identifier and name, redo log archive information, etc. are maintained in which of the following files?

  1. Force

  2. Instance creation

  3. The parameter file

  4. The archive file

  5. Control file


Correct Option: E
Explanation:

The entries such as the database identifier and name, redo log archive infoinformation, etc. are maintained in the control file.

A database uses and allocates free database space in which of the following logical storage structures?

  1. Read only

  2. Oracle datablock

  3. Table

  4. View

  5. Segment


Correct Option: B
Explanation:

A database uses and allocates free database space in oracle data blocks.

When the segment finishes execution, the extents are returned to the system in which of the following logical storage structures?

  1. The archive file

  2. Temporary segment

  3. Table

  4. View

  5. Instance creation


Correct Option: B
Explanation:

When the segment finishes execution, the extents in the temporary segment are returned to the system.

Which of the following background processes copies the online redk log files to archival storage?

  1. Archiver

  2. Lock manager server

  3. Log writer

  4. Process monitor

  5. The archive file


Correct Option: A
Explanation:

This background processes copies the online redo log files to archival storage.

- Hide questions