Oracle Database 11g: Administration I — Question 33

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

Answer options

• 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

Correct answer: C, D

Explanation

Option C is correct because all data dictionary views are indeed prefixed with DBA, ALL, or USER. Option D is also correct as the ALL prefixed views allow users to see objects they do not own, while options A, B, and E are incorrect as they misstate the accessibility and characteristics of the views.