Evaluate the following SELECT statement and view the Exhibit to examine its output:
SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status FROM user_constraints
WHERE table_name = ORDERS
Which two statements are true about the output? (Choose two.)
A.
In the second column, indicates a check constraint.
B.
The STATUS column indicates whether the table is currently in use.
C.
The R_CONSTRAINT_NAME column gives the alternative name for the constraint.
D.
The column DELETE_RULE decides the state of the related rows in the child table when the corresponding row is deleted from the parent table.
R_CONSTRAINT_NAME column of USER_CONSTRAINTS points to the parent constraint name of the given foreign key constraint.
Using this name you need to lookup USER_CONSTRAINTS to find out the parent owner and table.
R(Reference)
A.
In the second column, indicates two check constraint.
so A is incorrect…
CONSTRAINT_TYPE VARCHAR2(1) INDICATE Type of the constraint definition:
STATUS VARCHAR2(8) Enforcement status of the constraint(ENABLED OR DISABLED)
A,D