Multiple choice

Which of the following options is not contained in the Program Global Area (PGA)?

  1. Sort Area

  2. System Change Number (SCN)

  3. Session Information

  4. Cursor state

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The System Change Number (SCN) is stored in the SGA's control files and data headers, not in the PGA. The PGA contains session-specific memory areas like the Sort Area (for sorting operations), Session Information (user session data), and Cursor State (information about open cursors). The SCN is a database-wide mechanism for tracking changes and maintaining consistency, not session-specific.

Keep practicing — related questions