The ____ data dictionary view contains the definition of a constraint.
A) ALL_CONS_DEF
B) ALL_DEF_CONS
C) ALL_CONSTRAINTS
D) ALL_CONS_COLUMNS

Question

Quizplus · Accepted Answer

The ALL_CONSTRAINTS data dictionary view contains information about all constraints defined in the database, including their names, types, tables, columns, and status. This view also displays the constraint definitions, which can be used to understand the rules and conditions that apply to the data. Other views such as ALL_CONS_COLUMNS and ALL_CONS_DEF provide additional details about the columns and definitions of constraints, but the ALL_CONSTRAINTS view is the best choice for finding the definition of a specific constraint.

The ____ Data Dictionary View Contains the Definition of a Constraint