Multiple choice technology databases

Which table is used to identify the changes made to objects

  1. V$Session

  2. USER_CHANGES

  3. USER_OBJECTS

  4. USER_TRACKER
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The USER_OBJECTS data dictionary view contains information about all objects owned by the current user, including their creation and modification timestamps. This view can be used to track when objects were created, last modified, or dropped, making it useful for identifying changes made to database objects. V$Session is for session information, while USER_CHANGES and USER_TRACKER are not standard Oracle views for this purpose.

Keep practicing — related questions