Multiple choice technology databases

Cursor bind information is stored in which area of PGA.

  1. Cursor and SQL area

  2. Private SQL area

  3. Data Dictonary Cache

  4. Data Buffer Cache
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Cursor bind information and private runtime values are stored in the Private SQL Area within the PGA (Process Global Area). Each user session has its own Private SQL Area containing bind variable values, execution state, and other session-specific SQL information. The Cursor and SQL area terminology is less precise.

Keep practicing — related questions