nerdexam
Oracle

1Z0-052 · Question #30

Which statements listed below describe the data dictionary views? 1. These are stored in the SYSTEM tablespace 2. These are the based on the virtual tables 3. These are owned by the SYS user 4…

The correct answer is A. 1 and 3. Data dictionary views are physically stored in the SYSTEM tablespace and are owned by the SYS user. The other statements contain inaccuracies about their underlying structure, access rules, or catalog views.

Exploring the Oracle Database Architecture

Question

Which statements listed below describe the data dictionary views? 1. These are stored in the SYSTEM tablespace 2. These are the based on the virtual tables 3. These are owned by the SYS user 4. These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE 5. The V$FIXED_TABLE view can be queried to list the names of these views

Options

  • A1 and 3
  • B2,3 and 5
  • C1,2, and 5
  • D2,3,4 and 5

How the community answered

(29 responses)
  • A
    90% (26)
  • B
    7% (2)
  • D
    3% (1)

Why each option

Data dictionary views are physically stored in the SYSTEM tablespace and are owned by the SYS user. The other statements contain inaccuracies about their underlying structure, access rules, or catalog views.

A1 and 3Correct

Statement 1 is true because the base tables underlying the data dictionary are stored in the SYSTEM tablespace, and the views built on them reside there as well. Statement 3 is true because Oracle creates all data dictionary objects under the SYS schema to protect their integrity. Both facts are foundational properties of the Oracle data dictionary.

B2,3 and 5

Statement 2 is false - data dictionary views are based on internal base tables (not virtual/fixed X$ tables), and statement 5 is false because V$FIXED_TABLE lists dynamic performance (V$) and X$ fixed views, not data dictionary views; DICT or DICTIONARY is the correct view for that.

C1,2, and 5

Statement 2 is incorrect as explained above, making any combination that includes it wrong.

D2,3,4 and 5

Statement 4 is incorrect because normal users can query their own USER_ and public-synonym-exposed data dictionary views without setting O7_DICTIONARY_ACCESSIBILITY; that parameter controls broader SYS object access via SELECT ANY TABLE.

Concept tested: Oracle data dictionary structure and ownership

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/data-dictionary-and-dynamic-performance-views.html

Topics

#data dictionary views#SYS user#SYSTEM tablespace#V$FIXED_TABLE

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice