In the USER_CONSTRAINTS view,the value displayed in the CONSTRAINT_TYPE column will be a(n)____ for a FOREIGN KEY constraint.
A) C
B) K
C) N
D) R

Question

In the USER_CONSTRAINTS view,the value displayed in the CONSTRAINT_TYPE column will be a(n)____ for a FOREIGN KEY constraint.​
A) ​C
B) ​K
C) ​N
D) ​R

Quizplus · Accepted Answer

The value displayed in the CONSTRAINT_TYPE column will be 'R' for a FOREIGN KEY constraint. The possible values for this column are 'C' for check constraint, 'P' for primary key constraint, 'U' for unique key constraint, 'R' for foreign key constraint, and 'V' for a check option on a view.

In the USER_CONSTRAINTS View,the Value Displayed in the CONSTRAINT_TYPE Column