Multiple choice technology databases

What data dictionary view will display information about the columns in the database that have constraints?

  1. USER_CONSTRAINTS

  2. USER_CONS_COLUMNS

  3. DBA_CONSTRAINTS

  4. DBA_TABLE

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

USER_CONS_COLUMNS displays information about columns that participate in constraints. USER_CONSTRAINTS shows constraint definitions but not column-level details. DBA_CONSTRAINTS is the DBA-wide view, and DBA_TABLE doesn't exist (should be DBA_TABLES).