Multiple choice technology databases

View column associated with the constraint names view used is

  1. user_tab_columns

  2. user_cons_columns

  3. user_sys_columns

  4. all of above

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

USER_CONS_COLUMNS is the Oracle view that shows the mapping between constraints and the columns they reference. It contains constraint names, table names, column names, and position - essential for understanding which columns participate in multi-column constraints like composite primary keys.