nerdexam
Oracle

1Z0-062 · Question #210

Which set of statements is true about data dictionary views? 1) They are stored in the SYSTEM tablespace. 2) They are based on virtual tables 3) They are owned by the SYS user 4) They can be queried…

The correct answer is C. 1 and 3. https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT002

Exploring the Oracle Database Architecture

Question

Which set of statements is true about data dictionary views? 1) They are stored in the SYSTEM tablespace. 2) They are based on virtual tables 3) They are owned by the SYS user 4) They can be queried by a normal user only of the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE. 5) The V$FIXED_TABLE view can be queried to list the names of these views 6) They are owned by the SYSTEM user.

Options

  • A2, 5 and 6
  • B2, 3, 4, and 5
  • C1 and 3
  • D1, 2 and 3

How the community answered

(53 responses)
  • A
    6% (3)
  • B
    2% (1)
  • C
    91% (48)
  • D
    2% (1)

Explanation

https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT002

Topics

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

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice