Oracle Database Administration I — Question 96

Which two statements are true about the Oracle Data Dictionary? (Choose two.)

Answer options

• A. All data dictionary view join base tables to dynamic performance views.
• B. Data dictionary base tables can be queried directly.
• C. It is owned by the SYS user.
• D. It is owned by the SYSTEM user.
• E. Data dictionary views are always created with queries that join two or more base tables.

Correct answer: B, C

Explanation

The correct answers are B and C because data dictionary base tables can indeed be queried directly, and the Oracle Data Dictionary is owned by the SYS user. Options A and E are incorrect as they inaccurately describe the relationship between views and base tables, and option D is false since the SYSTEM user does not own the data dictionary.