Which two statements are true about * TABLES views?
A.
You must have SELECT privileges on a table to view it in ALL TABLES.
B.
You must have SELECT privileges on a table to view it in DBA TABLES.
C.
USER TABLES displays all tables owned by the current user.
D.
All TABLES displays all tables owned by the current user.
E.
You must have SELECT privileges on a table to view it in USER TABLES.
F.
All users can query DBA TABLES successfully.
The Answer Is:
C, F
This question includes an explanation.
Explanation:
For the *TABLES views in Oracle:
Option C: USER_TABLES displays all tables owned by the current user.
USER_TABLES is an Oracle data dictionary view that shows all tables owned by the user issuing the query.
Option F: All users can query DBA_TABLES successfully.
While all users can attempt to query DBA_TABLES, only users with the necessary privileges will receive results; however, the question's wording implies the ability to query, not necessarily to receive results.
Options A, B, D, and E are incorrect:
Option A and Option E are incorrect because ALL_TABLES and USER_TABLES show tables accessible to or owned by the current user, respectively, without requiring individual SELECT privileges.
Option B is incorrect because DBA_TABLES requires users to have the SELECT ANY TABLE privilege or equivalent, not SELECT privileges on each table.
Option D is incorrect because ALL_TABLES displays all tables that the current user has access to, not just those owned by them.
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"