Multiple choice technology databases

To View all constraint definition and name table used is

  1. sys_constraints

  2. user_constraints

  3. tab_constraints

  4. col_constraints
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The USER_CONSTRAINTS data dictionary view in Oracle contains information about all constraints owned by the current user, including constraint names, types, status, and related details. This is the standard view for querying constraint definitions and names in your schema.

Keep practicing — related questions