Multiple choice technology databases

Which of the following data dictionary views displays the objects owned by the user?

  1. DICTIONARY

  2. TABLE_PRIVILEGES

  3. ALL_VIEWS

  4. USER_OBJECTS
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

USER_OBJECTS lists all database objects owned by the current user. ALL_VIEWS displays views accessible to the user (not just owned), TABLE_PRIVILEGES shows privileges, and DICTIONARY describes data dictionary tables and views.

AI explanation

To answer this question, we need to understand the purpose of each data dictionary view.

Option A) DICTIONARY - This option is incorrect because the DICTIONARY view does not display the objects owned by the user. It provides information about the database dictionary itself.

Option B) TABLE_PRIVILEGES - This option is incorrect because the TABLE_PRIVILEGES view displays information about the table-level privileges granted to users, not the objects owned by the user.

Option C) ALL_VIEWS - This option is incorrect because the ALL_VIEWS view displays information about all views accessible to the user, not just the ones owned by the user.

Option D) USER_OBJECTS - This option is correct because the USER_OBJECTS view displays information about the objects owned by the user. It includes tables, views, indexes, sequences, procedures, functions, packages, and synonyms.

Therefore, the correct answer is option D) USER_OBJECTS. This option is correct because it displays the objects owned by the user.

Keep practicing — related questions