Multiple choice technology databases

Which one is useful to check whether the columns in a join view can be updated...?

  1. user_views

  2. all_views

  3. user_updatable_columns

  4. dba_views

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

The USER_UPDATABLE_COLUMNS data dictionary view specifically shows which columns in a view can be updated through DML operations. Other views (USER_VIEWS, ALL_VIEWS, DBA_VIEWS) contain view definitions, not updatability metadata.