Multiple choice

Which type of information does 'Shared Pool' stores in SGA (System Global Area)?

  1. It stores the most recently used blocks of data.

  2. It stores a log of changes made to the database.

  3. It contains information such as the parse tree and execution plan for the corresponding statement.

  4. It uses a non-shared SQL area to process every unique SQL statement submitted to the database.

  5. It is used to store the execution state of the database.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A shared SQL stores such information and execution plans for all the database statements.

Keep practicing — related questions