Memory Architecture   «Prev  Next»

Oracle PGA Memory - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What does the acronym PGA stand for?
Please select the best answer.
  A. Process Global Area
  B. Program Global Area
  C. PL/SQL Global Area
  D. Primary Global Area

2. Identify two items from the following list that are stored in the PGA under a dedicated server configuration:
Please select all the correct answers.
  A. Private SQL Areas
  B. PL/SQL code for built-in packages
  C. PL/SQL variables
  D. SQL execution plans

3. How many processes can access one PGA?
Please select the best answer.
  A. One
  B. Three
  C. Five
  D. Ten

4. Which part of a private SQL area holds bind variable values, and is freed only when the cursor is closed?
Please select the best answer.
  A. Runtime Area
  B. Shared SQL Area
  C. Sort Area
  D. Persistent Area

5. Under a shared server configuration, where does a session's UGA typically reside?
Please select the best answer.
  A. Always in the PGA, the same as under dedicated server
  B. In the Large Pool if one is configured, otherwise the Shared Pool
  C. In the redo log buffer
  D. It is discarded between calls and cannot be reused