Home › Quizzes › Oracle Database Architecture

Oracle Database Architecture

Covers Oracle database memory structures, storage components, recovery mechanisms, RMAN, and distributed transactions

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following 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. The data dictionary cache
  5. Registration of database
Question 2 Multiple Choice (Single Answer)

Which of the following is in turn made up the persistent area that contains bind information and a run time area that is created as soon as an execute request is initiated?

  1. SQL work area
  2. Private SQL area
  3. The stream pool
  4. Instance creation
  5. Image copy
Question 3 Multiple Choice (Single Answer)

Which of the following files facilitates the Oracle mechanism to recover from an instance failure or a media failure?

  1. Redo log files
  2. The password file
  3. Data files
  4. The stream pool
  5. Instance creation
Question 4 Multiple Choice (Single Answer)

The database application issuing the distributed transaction is directly connected to the node acting as the which of the following?

  1. Client
  2. Database server
  3. RMAN client
  4. Global coordinator
  5. Media management application
Question 5 Multiple Choice (Single Answer)

Which of the following prevents SQL statements from being repeatedly parsed thus improving performance during execution of SQL statements?

  1. The data dictionary cache
  2. Library cache
  3. The stream pool
  4. SQL work area
  5. Instance creation
Question 6 Multiple Choice (Single Answer)

In which of the following phases does RMAN determine the objects accessed by a command?

  1. Execution phase
  2. Shrinking phase
  3. The local agent
  4. In-doubt transaction
  5. Compilation phase
Question 7 Multiple Choice (Single Answer)

Two specific caches library cache and the data dictionary cache form which of the following pools?

  1. The java pool
  2. The stream pool
  3. SQL work area
  4. The shared pool
  5. Data files
Question 8 Multiple Choice (Single Answer)

Which of the following files is very useful in the event of a failure and is used for recovery purposes?

  1. Archive file
  2. Data file
  3. Instance creation
  4. Automatic datafiles creation
  5. Password file
Question 9 Multiple Choice (Single Answer)

Which of the following has the main functions to provide session memory for the shared server environment and parallel execution message buffers?

  1. The large pool
  2. The stream pool
  3. The java pool
  4. The password file
  5. Mount
Question 10 Multiple Choice (Single Answer)

Which of the following file stores the name of the database, the names and locations of the tablespaces in the database, the location of the redo files etc.?

  1. Extent
  2. Control file
  3. Data file
  4. The stream pool
  5. Instance creation
Question 11 Multiple Choice (Single Answer)

Which of the following files allows you to to specify the values to attributes that can be enforced without bouncing the database as well as after re-starting the database?

  1. Instance creation
  2. The password file
  3. Data file
  4. The stream pool
  5. The server parameter file
Question 12 Multiple Choice (Single Answer)

Which of the following stores the most critical data which never remains in-doubt, even if a failure occurs?

  1. Standby database
  2. Duplicate database
  3. Commit point site
  4. In-doubt transaction
  5. Database server
Question 13 Multiple Choice (Single Answer)

The contents of which of the following are essential for instance recovery purposes?

  1. The java pool
  2. Redo log buffer
  3. The stream pool
  4. Proxy archived log backups
  5. Duplicate database
Question 14 Multiple Choice (Single Answer)

In which of the following modes does the transaction require only to read the data item?

  1. Exclusive mode
  2. Shrinking phase
  3. Shared mode
  4. The local agent
  5. In-doubt transaction
Question 15 Multiple Choice (Single Answer)

Which of the following will frequently group together similar objects such as relations for a specific business area or a specific function?

  1. Segment
  2. Database block
  3. Tablespace
  4. Data file
  5. Instance creation
← Back to Quizzes