Multiple choice technology databases

Which data dictionary object is used to retrieve the information about the tables from a given schema?

  1. USER_TABLES

  2. USER_TABS

  3. Both 1 & 2

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Oracle data dictionary, USER_TABLES is the correct view name to retrieve information about tables owned by the current user. USER_TABS is not a valid Oracle dictionary view. The answer is A only. Other valid views include ALL_TABLES (tables accessible to user) and DBA_TABLES (all tables in database), but the question specifically asks about a given schema.

Keep practicing — related questions