Home › Quizzes › Oracle Database Architecture

Oracle Database Architecture

Quiz covering Oracle database memory structures, background processes, storage components, and recovery mechanisms

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following memory components of the system global area is used by the Oracle streams product for its functioning?

  1. Java pool
  2. Shared pool
  3. Session memory
  4. Opening the database
  5. Stream pool
Question 2 Multiple Choice (Single Answer)

Which of the following background processes writes modified blocks from the database buffer cache to the datafiles?

  1. Log writer
  2. Job queue process
  3. Database writer
  4. Oracle server
  5. Mounting the database
Question 3 Multiple Choice (Single Answer)

Which of the following memory components of the program global area is used for operations such as sorting, hash-joins operations etc.?

  1. Session memory
  2. Java pool
  3. Log writer
  4. SQL work area
  5. Archive files
Question 4 Multiple Choice (Single Answer)

Which of the following is a set of extents allocated for a certain logical structure such as a table?

  1. Segment
  2. Views
  3. Database block
  4. PFILE
  5. Duplicate database
Question 5 Multiple Choice (Single Answer)

Which of the following background processes performs recovery when a failed instance starts up again?

  1. System monitor
  2. Log writer
  3. Job queue process(es)
  4. Shared pool
  5. Read Only
Question 6 Multiple Choice (Single Answer)

The database identifier and name entries are maintained in the which of the following files?

  1. Parameter file
  2. Control file
  3. Password file
  4. Views
  5. PFILE
Question 7 Multiple Choice (Single Answer)

Which of the following background processes performs process recovery when a user process fails?

  1. Job queue process(es)
  2. Log writer
  3. Process monitor
  4. Shared pool
  5. FORCE
Question 8 Multiple Choice (Single Answer)

A database is divided into logical storage units called ____________ , which groups related logical structures together.

  1. oracle datablock
  2. view
  3. tablespace
  4. archive file
  5. mounting the database
Question 9 Multiple Choice (Single Answer)

Which of the following memory components of the program global area is in turn made up the persistent area?

  1. Instance creation
  2. Archive file
  3. Session memory
  4. Shared pool
  5. Private SQL area
Question 10 Multiple Choice (Single Answer)

The information in which of the following is used during database recovery?

  1. Database block
  2. Data segment
  3. Rollback segment
  4. Views
  5. Parameter file
Question 11 Multiple Choice (Single Answer)

The data of logical database structures such as tables and indexes are physically stored in the __________ files allocated for a database.

  1. archive files
  2. data files
  3. parameter file
  4. instance creation
  5. Read Only
Question 12 Multiple Choice (Single Answer)

The contents of which of the memory components of the system global area is essential for instance recovery purposes?

  1. Session memory
  2. Java pool
  3. Shared pool
  4. Redo log buffer
  5. Opening the database
Question 13 Multiple Choice (Single Answer)

Which of the following background processes copies the online redo log files to archival storage after a log switch has occurred?

  1. Archive files
  2. Archiver
  3. Log writer
  4. Job queue processes
  5. Mounting the database
Question 14 Multiple Choice (Single Answer)

The contents of which of the following memory components of the system global area are written to data files on disk by the database writer background process?

  1. Database buffer cache
  2. Java pool
  3. Shared pool
  4. Session memory
  5. Database block
Question 15 Multiple Choice (Single Answer)

The information in which of the following files are used only to recover the database from a system or media failure?

  1. Archive file
  2. Redo log file
  3. Parameter file
  4. Instance creation
  5. Read Only
← Back to Quizzes