Multiple choice technology databases

When SQL query is parsed then it will look first definitions of table exist in following area.

  1. Shared Pool

  2. Data Dictionary Cache

  3. Data Buffer Cache

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

When a SQL query is parsed, Oracle first checks the Data Dictionary Cache to verify that referenced tables, columns, and other objects exist and the user has proper privileges. The Library Cache stores parsed SQL, but object definitions come from the Data Dictionary Cache. The buffer cache stores data blocks, not metadata.

Keep practicing — related questions