Multiple choice

Which of the following memory structures contains the information used by the server process to validate the user privileges?

  1. Buffer cache

  2. Library cache

  3. Data dictionary cache

  4. Redo log buffer cache
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Data Dictionary Cache stores information about database objects, users, privileges, and other metadata. When a server process needs to validate user privileges, it checks the data dictionary cache to see what permissions that user has. The Buffer cache stores data blocks. The Library cache stores parsed SQL statements and execution plans. The Redo log buffer stores changes before writing to redo log files - none of these contain privilege information.

Keep practicing — related questions