Memory Architecture   «Prev  Next»

Oracle PGA - 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