nerdexam
Oracle

1Z0-071 · Question #263

Which two are true about the data dictionary? (Choose two.)

The correct answer is A. The SYS user owns all base tables and user-accessible views in the data dictionary. E. Base tables in the data dictionary have the prefix DBA_. https://docs.oracle.com/cd/B28359_01/server.111/b28318/datadict.htm#CNCPT1215

Managing Objects with Data Dictionary Views

Question

Which two are true about the data dictionary? (Choose two.)

Options

  • AThe SYS user owns all base tables and user-accessible views in the data dictionary.
  • BAll users have permissions to access all information in the data dictionary by default.
  • CThe data dictionary is constantly updated to reflect changes to database objects, permissions,
  • DAll user actions are recorded in the data dictionary.
  • EBase tables in the data dictionary have the prefix DBA_.

How the community answered

(51 responses)
  • A
    82% (42)
  • B
    10% (5)
  • C
    6% (3)
  • D
    2% (1)

Explanation

https://docs.oracle.com/cd/B28359_01/server.111/b28318/datadict.htm#CNCPT1215

Topics

#data dictionary#SYS user#DBA_ views#dictionary ownership

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice