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

The correct answer is B. Views with the prefix ALL_ display metadata for objects to which the current user has access. C. Views with the prefix DBA_ display only metadata for objects in the SYS schema. ALL_ -include objects all objects (from all schemas) accessible to the current user. https://dataedo.com/blog/useful-oracle-data-dictionary-queries-every-dba-should-have https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm

Managing Objects with Data Dictionary Views

Question

Options

AViews with the prefix ALL_, DBA_ and USER_ are not all available for every type of metadata.
BViews with the prefix ALL_ display metadata for objects to which the current user has access.
CViews with the prefix DBA_ display only metadata for objects in the SYS schema.
DThe data dictionary does not store metadata in tables.
EThe data dictionary is accessible when the database is closed.

How the community answered

(25 responses)

A
4% (1)
B
80% (20)
D
4% (1)
E
12% (3)

Explanation

ALL_ -include objects all objects (from all schemas) accessible to the current user. https://dataedo.com/blog/useful-oracle-data-dictionary-queries-every-dba-should-have https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm

Topics

#data dictionary#ALL_ views#DBA_ views#metadata access

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice