Home › Quizzes › Oracle Database Architecture

Oracle Database Architecture

Covers Oracle database architecture topics including background processes, memory components (SGA, PGA), storage structures, and database files.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following background processes is an optional background process present only when a shared server configuration is used?

  1. Job queue process
  2. Queue monitor
  3. Dispatcher
  4. Archiver
  5. Mounting the database
Question 2 Multiple Choice (Single Answer)

At the finest level of granularity, Oracle database data is stored in which of the following logical storage structures?

  1. Segment
  2. Extent
  3. Oracle datablock
  4. Views
  5. Instance creation
Question 3 Multiple Choice (Single Answer)

The entries, such as current online redo log file sequence number, timestamp of database creation, etc., are maintained in which of the following files?

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

The information in which of the following files is used only to recover the database from a system failure that prevents database data from being written to the data files?

  1. Instance creation
  2. Redo log file
  3. The archive file
  4. The parameter file
  5. Read Only
Question 5 Multiple Choice (Single Answer)

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

  1. Recoverer
  2. Archiver
  3. Job queue processes
  4. Queue monitor
  5. Opening the database
Question 6 Multiple Choice (Single Answer)

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

  1. Recover
  2. Session memory
  3. The stream pool
  4. SQL workarea
  5. Java pool
Question 7 Multiple Choice (Single Answer)

Which of the following background processes writes the redo log entries sequentially into an online redo log?

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

A tablespace can have many _______________ files associated with it.

  1. Abort
  2. data files
  3. the parameter file
  4. the archive file
  5. instance creation
Question 9 Multiple Choice (Single Answer)

Which of the following memory components of the SGA is used to hold data blocks read from data files by server processes?

  1. The stream pool
  2. The java pool
  3. Session Memory
  4. Database buffer cache
  5. Opening the database
Question 10 Multiple Choice (Single Answer)

Which of the following always opens one database?

  1. The Oracle instance
  2. The Oracle server
  3. The Oracle database
  4. Recover
  5. The archive file
Question 11 Multiple Choice (Single Answer)

Which of the following logical storage structures commonly group together all application objects using some administrative operations?

  1. Extents
  2. Segments
  3. Views
  4. The password file
  5. Tablespaces
Question 12 Multiple Choice (Single Answer)

Which of the following background processes is responsible for cleaning up the cache and freeing resources that the process was using?

  1. Process monitor
  2. Queue monitor
  3. Job queue processes
  4. Archiver
  5. Mounting the database
Question 13 Multiple Choice (Single Answer)

In a dedicated server environment, which of the following memory area is created in the program global area of their server process?

  1. Session memory
  2. The java pool
  3. The stream pool
  4. The archive file
  5. Private SQL area
Question 14 Multiple Choice (Single Answer)

In which of the following memory components of the SGA are the sizes of the two caches, such as library cache and the data dicitionary caches not set individually and are automatically determined by the Oracle server?

  1. The stream pool
  2. The shared pool
  3. The java pool
  4. Session memory
  5. The password file
Question 15 Multiple Choice (Single Answer)

Which of the following memory components of the SGA is a circular buffer that contains redo entries?

  1. The stream pool
  2. Redo log buffer
  3. The java pool
  4. Session memory
  5. The archive file
← Back to Quizzes