Multiple choice technology databases

We can view the constraint details from following data dictionary views

  1. user_constraints

  2. user_tables

  3. user_cons_columns

  4. all_tab_cols

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

Oracle data dictionary views provide metadata about database objects. USER_CONSTRAINTS displays constraint definitions for the current user's tables. USER_CONS_COLUMNS shows which columns participate in which constraints. USER_TABLES and ALL_TAB_COLS contain table and column information but not constraint details.