Shared Pool   «Prev  Next»

Shared Pool Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. Which is the best way to reduce contention on your library cache?
Please select the best answer.
  A. Pin all SQL statements in the shared pool.
  B. Always use host variables in all SQL.
  C. Place all SQL into packages.
  D. Place frequently used objects into packages and pin them into the shared pool.

2. What is the best way to identify frequently used packages and procedures?
Please select the best answer.
  A. Query the V$DB_OBJECT_CACHE view.
  B. Use Oracle auditing.
  C. Query the Oracle data dictionary views.
  D. Query the V$SGASTAT view.

3. Which is a valid reason to place all SQL in packages? (Please select all that apply.)
Please select all the correct answers.
  A. The SQL can be pinned in the shared pool.
  B. The SQL will be uniform in syntax with identical host variables.
  C. The SQL can be extracted from the dictionary and tuned at any time.
  D. The SQL will run faster when inside a package.

4. Which of the following are residents of the library cache? (Choose all that apply.)
Please select all the correct answers.
  A. SQL source
  B. Dictionary objects rows
  C. SQL cursors
  D. V$ views

5. What is the best init.ora remedy for problems in the library cache?
Please select the best answer.
  A. Increase the shared_pool_size init.ora parameter.
  B. Set cursor_space_for_time to TRUE.
  C. Increase session_cached_cursors.