Home › Quizzes › Oracle Database Architecture and SGA

Oracle Database Architecture and SGA

Questions covering Oracle System Global Area (SGA) components, background processes, and storage structures

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

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
Question 2 Multiple Choice (Single Answer)

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
Question 3 Multiple Choice (Single Answer)

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
Question 4 Multiple Choice (Single Answer)

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
Question 5 Multiple Choice (Single Answer)

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

  1. Recover
  2. Segments
  3. Views
  4. Tablespace
  5. Tables
Question 6 Multiple Choice (Single Answer)

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
Question 7 Multiple Choice (Single Answer)

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
Question 8 Multiple Choice (Single Answer)

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
Question 9 Multiple Choice (Single Answer)

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
Question 10 Multiple Choice (Single Answer)

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
Question 11 Multiple Choice (Single Answer)

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
Question 12 Multiple Choice (Single Answer)

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
Question 13 Multiple Choice (Single Answer)

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
Question 14 Multiple Choice (Single Answer)

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
Question 15 Multiple Choice (Single Answer)

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
← Back to Quizzes