Which two statements are true about * _TABLES views?
A.
You must have ANY TABLE system privileges, or be granted object privilges on the table, to viewa tabl e in DBA TABLES.
B.
USER TABLES displays all tables owned by the current user.
C.
You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in USER_TABLES.
D.
ALL TABLES displays all tables owned by the current user.
E.
You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in ALL_TABLES.
F.
All users can query DBA_TABLES successfully.
The Answer Is:
B, D
This question includes an explanation.
Explanation:
In Oracle, *_TABLES views provide information about tables.
B. USER_TABLES displays all tables owned by the current user, making this statement true. No additional privileges are required to see your own tables.
D. ALL_TABLES displays all tables that the current user has access to, either through direct ownership or through privileges, making this statement true.
A, C, E, and F are incorrect. Specifically:
A and E are incorrect because you do not need ANY TABLE system privileges to view tables in DBA_TABLES or ALL_TABLES; you need the SELECT_CATALOG_ROLE or equivalent privileges.
C is incorrect because as a user, you do not need additional privileges to see your own tables in USER_TABLES.
F is incorrect because not all users can query DBA_TABLES; this requires specific privileges or roles.