Memory Architecture   «Prev  Next»

Shared Oracle Pools and Large Pools - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Identify two uses for the large pool.
Please select all the correct answers.
  A. To hold large buffers allocated for backup and restore operations
  B. To hold parse trees and execution plans for large SQL statements
  C. To provide overflow space for use by large objects in the shared pool
  D. To hold session memory allocated by the multi-threaded server

2. Which of the following SQL statements will Oracle consider identical?
Please select all the correct answers.
  A. delete from COIN where date = 1999
  B. delete from COIN where date=1999
  C. delete from coin where date=1999
  D. delete from COIN where date=1999

3. Identify three things that you will find in the shared pool.
Please select all the correct answers.
  A. SQL execution plans
  B. The redo log buffer
  C. The LRU List
  D. Shared data blocks
  E. Data dictionary records
  F. PL/SQL packages