Multiple choice

If a database is queried with the following command:

SELECT object_name FROM all_objects WHERE object_type = 'TABLE';

Which of the following values are displayed?

  1. Only the names of all the tables that can be accessed.

  2. Only the names of all the objects that can be accessed.

  3. Only the names of the objects that are owned.

  4. Only the names of the tables that are owned.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The ALL_OBJECTS data dictionary view shows all objects accessible to the current user, including objects owned by the user plus those on which privileges have been granted. By filtering WHERE object_type='TABLE', only table names are returned. USER_OBJECTS would show only owned objects.

Keep practicing — related questions