1Z0-082 practice question 10 of 25
Which three statements are true about the Oracle Data Dictionary? (Choose three.)
Full set: 142 questionsThe 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.
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.
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.
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
