Home › Quizzes › Oracle Database Architecture

Oracle Database Architecture

Test your knowledge of Oracle database architecture including memory structures (SGA, PGA), logical and physical storage components, background processes, and recovery mechanisms.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

The entries such as Tablespace names, the database identifier and name, etc., are maintained in which of the following file?

  1. The archive file
  2. Control file
  3. The parameter file
  4. Instance creation
  5. Recover
Question 2 Multiple Choice (Single Answer)

Which of the following memory components of the PGA contains bind information and a runtime area that is created as soon as an execute request is initiated?

  1. Private SQL area
  2. SQL work area
  3. Mounting the database
  4. Redo log buffer
  5. The stream pool
Question 3 Multiple Choice (Single Answer)

Which of the following background processes is used to resolve distributed transaction that are pending due to a network failure in a distributed database?

  1. Recoverer
  2. Archiver
  3. System monitor
  4. Log writer
  5. Mounting the database
Question 4 Multiple Choice (Single Answer)

Which of the following logical storage structures are groups of one or more tables physically stored together and share common columns?

  1. Oracle datablock
  2. Segment
  3. Instance creation
  4. Read only
  5. Clusters
Question 5 Multiple Choice (Single Answer)

Two specific caches; library cache and the data dictionary cache form which of the following memory components of the SGA?

  1. The stream pool
  2. The java pool
  3. Opening the database
  4. SQL work area
  5. The shared pool
Question 6 Multiple Choice (Single Answer)

Which of the following background processes are used for batch processing?

  1. Queue monitors
  2. System monitor
  3. Job queue processes
  4. Log writer
  5. Mounting the database
Question 7 Multiple Choice (Single Answer)

Which of the following files belong to only one tablespace?

  1. The archive file
  2. Data file
  3. The parameter file
  4. Instance creation
  5. Read only
Question 8 Multiple Choice (Single Answer)

Which of the following memory components of the SGA is managed in a manner that free blocks are always made available for new blocks being read into memory?

  1. The stream pool
  2. The java pool
  3. The database buffer cache
  4. SQL work area
  5. Read Only
Question 9 Multiple Choice (Single Answer)

The information in which of the following logical storage structures is used during database recovery to generate read-consistent database information?

  1. Data segment
  2. Tablespace
  3. The archive file
  4. Rollback segment
  5. Opening the database
Question 10 Multiple Choice (Single Answer)

When a statement is executed, Oracle looks for an identical statement/execution plan in which of the following memory components of the SGA?

  1. The parameter file
  2. SQL work area
  3. Redo log buffer
  4. The java pool
  5. Library cache
Question 11 Multiple Choice (Single Answer)

Which of the following logical storage structures are created when a SQL statement needs a temporary work area to complete execution?

  1. Data segment
  2. Temporary segments
  3. Tablespace
  4. SQL work area
  5. Mounting the database
Question 12 Multiple Choice (Single Answer)

Which of the following logical storage structures has a one-to-one correspondence with a user account in the Oracle database?

  1. Oracle datablock
  2. Schema
  3. Segment
  4. Tablespace
  5. The archive file
Question 13 Multiple Choice (Single Answer)

Which of the following memory components of the SGA consists of blocks that hold data dictionary information read in from the data files?

  1. The stream pool
  2. Redo log buffer
  3. The data dictionary cache
  4. SQL work area
  5. Read Only
Question 14 Multiple Choice (Single Answer)

Which of the following files are used to recover changed data that was in memory at the time of a crash?

  1. Instance creation
  2. The password file
  3. Redo log files
  4. The parameter file
  5. Force
Question 15 Multiple Choice (Single Answer)

Which of the following background processes is used for inter-instance locking in real application clusters?

  1. Lock manager server process
  2. Granularity of locking
  3. System monitor
  4. Process monitor
  5. Opening a database
← Back to Quizzes