Which two are true about data dictionary views? (Choose two.)
A. DBA prefixed views are accessible when a database is in mount state
B. A user can query the DBA prefixed with DBA or ALL or USER
C. All data dictionary views are prefixed with DBA or ALL or USER
D. A user may not necessarily be the owner of all objects that can be viewed by using the ALL prefixed views
E. ALL or USER prefixed views display output that are subsets of the output from the DBA prefixed data views
Hello,
I think D and E are correct. Because i checked in the oracle slide that there are following information:
>>
Not all dictionary views start with the prefix DBA_, ALL_, and USER_. The following views or
synonyms to views are exceptions to this:
• AUDIT_ACTIONS
• CAT
• CHANGE_PROPAGATIONS
…
<<
Thank you
Vinh