Oracle Database SQL — Question 180

Which two statements are true about the data dictionary?

Answer options

• A. The data dictionary is accessible when the database is closed.
• B. The data dictionary does not store metadata in tables.
• C. Views with the prefix ALL_, DBA_ and USER_ are not all available for every type of metadata.
• D. Views with the prefix DBA_ display only metadata for objects in the SYS schema.
• E. Views with the prefix ALL_ display metadata for objects to which the current user has access.

Correct answer: C, E

Explanation

Option C is correct because it acknowledges that certain views may not be available for all types of metadata. Option E is also accurate as it specifies that ALL_ views provide access to metadata for objects the current user can access. Options A, B, and D are incorrect because they either misrepresent the accessibility of the data dictionary, its storage method, or the scope of DBA_ views.