Multiple choice

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 is a data dictionary view that displays all objects owned by the current user, including tables, views, indexes, procedures, and other database objects. It only shows objects where the user is the owner, unlike ALL_OBJECTS which shows objects accessible to the user (including ones owned by others with privileges).

Keep practicing — related questions