1Z0-082 practice question 10 of 25

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

Full set: 142 questions
Answer options
A: Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
B: The data dictionary is created and maintained by the database administrator
C: Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary Correct answer
D: Base tables can be queried directly Correct answer
E: It is owned by the SYSTEM user
F: Usernames of all users including database administrators are stored in the data dictionary Correct answer
Correct Answer:
C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary; D. Base tables can be queried directly; F. Usernames of all users including database administrators are stored in the data dictionary
Explanation

The Oracle Data Dictionary is a collection of internal tables and views containing database metadata. Views with prefixes like DBA, ALL, and USER (and CDB in multitenant) provide different scopes of the same information by querying the same underlying base tables. All user account information, including administrators, is stored in the data dictionary and is visible through views like DBAUSERS. While strongly discouraged by Oracle for stability and security reasons, the underlying base tables (e.g., SYS.TAB$) can be directly queried by highly privileged users such as SYS.

Why Incorrect

A. Data dictionary views are created from joins of internal base tables only, not from tables defined by a DBA.
B. The Oracle Database server automatically creates and maintains the data dictionary; it is not a manual task for the DBA.
E. The data dictionary is owned by the SYS user, not the SYSTEM user.

References

1. Oracle Database Concepts, 19c, Chapter 7, "Data Dictionary and Dynamic Performance Views": This chapter states, "The SYS user owns all base tables and user-accessible views of the data dictionary." This confirms option E is incorrect and implies SYS ownership. It also states, "The database modifies the data dictionary automatically," which confirms option B is incorrect.

2. Oracle Database Concepts, 19c, Chapter 7, "Data Dictionary and Dynamic Performance Views", Section "Data Dictionary Views": This section explains the hierarchy: "Some views are organized in a hierarchy of USER, ALL, and DBA." This supports option C.

3. Oracle Database Concepts, 19c, Chapter 7, "Data Dictionary and Dynamic Performance Views", Section "Contents of the Data Dictionary": This section lists the contents, including "The names of Oracle Database users," which validates option F.

4. Oracle Database Concepts, 19c, Chapter 7, "Data Dictionary and Dynamic Performance Views", Section "Data Dictionary Base Tables": This section notes, "...database administrators should rarely, if ever, read them directly." This phrasing confirms that direct queries are possible, although not recommended, making option D a true statement. It also clarifies that views are built on these base tables, making option A incorrect.

Scroll to Top