Oracle Database SQL — Question 116

Which two are true about the data dictionary? (Choose two.)

Answer options

• A. The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.
• B. All user actions are recorded in the data dictionary.
• C. All users have permissions to access all information in the data dictionary by default.
• D. The SYS user owns all base tables and user-accessible views in the data dictionary.
• E. Base tables in the data dictionary have the prefix DBA_.

Correct answer: A, D

Explanation

Option A is correct because the data dictionary is designed to be continually updated as changes occur within the database. Option D is also accurate, as the SYS user indeed owns the base tables and views. Options B and C are incorrect because not all user actions are recorded, and access to the data dictionary is not granted to all users by default. Option E is misleading; while some tables use the DBA_ prefix, not all base tables do.