nerdexam
Oracle

1Z0-082 · Question #104

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

The correct answer is C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference D. Base tables can be queried directly F. Usernames of all users including database administrators are stored in the data dictionary. See the full explanation below for the reasoning.

Oracle Database Architecture

Question

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

Options

  • AData dictionary views are created by joins of dictionary base tables and DBA-defined tables
  • BThe data dictionary is created and maintained by the database administrator
  • CViews with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference
  • DBase tables can be queried directly
  • EIt is owned by the SYSTEM user
  • FUsernames of all users including database administrators are stored in the data dictionary

How the community answered

(37 responses)
  • A
    3% (1)
  • B
    8% (3)
  • C
    76% (28)
  • E
    14% (5)

Topics

#data dictionary#CDB/DBA/ALL/USER views#base tables#SYSTEM user

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice