Home › Quizzes › Oracle Database Architecture and Administration

Oracle Database Architecture and Administration

This test covers Oracle database architecture concepts including System Global Area (SGA), Program Global Area (PGA), logical storage structures, and background processes. Ideal for GATE, IT certification, and Oracle database administration exam preparation.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following logical storage structures is/are created on one or more columns of a table?

  1. Recover
  2. Tables
  3. Extent
  4. Indexes
  5. Segment
Question 2 Multiple Choice (Single Answer)

The entries such as names and locations of data files and online redo log files, begin and end of undo segments etc. are maintained in which of the following files?

  1. Archive file
  2. Parameter file
  3. Control file
  4. Instance creation
  5. Restrict
Question 3 Multiple Choice (Single Answer)

Which of the following memory components of the PGA is in turn made up the persistent area that contains bind information and runtime memory structures?

  1. Read only
  2. Java pool
  3. Stream pool
  4. Session memory
  5. Private SQL area
Question 4 Multiple Choice (Single Answer)

Which of the following logical storage structures do not affect application design?

  1. Clusters
  2. Tables
  3. Extent
  4. Segment
  5. Registration
Question 5 Multiple Choice (Single Answer)

Which of the following background processes is active only when a database is in ARCHIVELOG mode?

  1. Mounting the database
  2. Archiver
  3. Process monitor
  4. Queue monitor
  5. Lock manager server
Question 6 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?

  1. Checkpoint process
  2. Lock manager server
  3. Queue monitor
  4. Process monitor
  5. Mounting the database
Question 7 Multiple Choice (Single Answer)

Which of the following memory components of the SGA contains share memory construct such as shared SQL areas?

  1. Read only
  2. Shared pool
  3. Stream pool
  4. Java pool
  5. Session memory
Question 8 Multiple Choice (Single Answer)

Which of the following consists of internal memory structures and processes?

  1. Oracle server
  2. Oracle database
  3. Instance creation
  4. Abort
  5. Oracle instance
Question 9 Multiple Choice (Single Answer)

Which of the following background processes enables job queue clients to use more job queue processes when required?

  1. Job queue process
  2. Process monitor
  3. Queue monitor
  4. Lock manager server
  5. Opening the database
Question 10 Multiple Choice (Single Answer)

Which of the following logical storage structures does not actually contain data?

  1. Opening the database
  2. Tables
  3. Extent
  4. View
  5. Segment
Question 11 Multiple Choice (Single Answer)

Which of the following memory components of the PGA is used for operations such as bitmap merge, sorting etc.?

  1. SQL work area
  2. Session memory
  3. Instance creation
  4. Recover
  5. Stream pool
Question 12 Multiple Choice (Single Answer)

Which of the following memory components of the SGA stores the most recently used block of data?

  1. Stream pool
  2. Database buffer cache
  3. Java pool
  4. Force
  5. Session memory
Question 13 Multiple Choice (Single Answer)

Which of the following background processes cleans up temporary segments that are no longer in use and recovers terminated transactions skipped during recovery?

  1. Queue monitor
  2. System monitor
  3. Lock manager server
  4. Process monitor
  5. Mounting the database
Question 14 Multiple Choice (Single Answer)

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

  1. Parameter file
  2. Password file
  3. Redo log file
  4. Instance creation
  5. Read only
Question 15 Multiple Choice (Single Answer)

Which of the following memory components of the SGA is a circular buffer that stores redo entries - a log of changes made to the database?

  1. Stream pool
  2. Java pool
  3. Redo log buffer
  4. Session memory
  5. Read only
← Back to Quizzes