Multiple choice technology databases

which of the following views identify the status of the view in the database

  1. USER_VIEWS

  2. USER_TAB_COLUMNS

  3. USER_TABLES

  4. USER_OBJECTS

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

USER_OBJECTS is the correct Oracle system view that shows all objects owned by the current user, including views and their status (VALID or INVALID). USER_VIEWS contains view text/definitions but not status. USER_TAB_COLUMNS describes column information, and USER_TABLES only lists tables.