Oracle Database SQL — Question 246

Which two statements are true about *_TABLES views? (Choose two.)

Answer options

• A. USER_TABLES displays all tables owned by the current user.
• B. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in USER_TABLES.
• C. All users can query DBA_TABLES successfully.
• D. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in DBA_TABLES.
• E. ALL_TABLES displays all tables owned by the current user.
• F. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in ALL_TABLES.

Correct answer: A, F

Explanation

Option A is correct because USER_TABLES indeed lists all tables owned by the current user. Option F is also correct, as it states the requirement of having ANY TABLE system privileges or object privileges to view tables in ALL_TABLES. Options B, C, D, and E are incorrect due to misrepresentations of privileges and access rights associated with the respective views.