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’;
CONSTRAINT_NAME CON SEARCH_CONDITI ON R_CONSTRAINT_NAME DELETE_RULE STATUS
ORDER_DATE_NN C "ORDER_DATE" IS NOT NULL ENABLED
ORDER_CUSTOMER_ID_NN C "CUSTOMER_ID" IS NOT NULL ENABLED
ORDER_MODE_LOV C order _mode in (‘direct’, ‘online’) ENABLED
ORDER TOTAL MIN C order total >= 0 ENABLED
ORDER PK P ENABLED
ORDERS CUSTOMER ID R CUSTOMERS ID SET NULL ENABLED
ORDERS SALES REP R EMP EMP ID SET NULL ENABLED
Which two statements are true about the output? (Choose two.)
A. The R_CONSTRAINT_NAME column gives the alternative name for the constraint.
B. In the second column, ‘c’ indicates a check constraint.
C. The STATUS column indicates whether the table is currently in use.
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
BD
(FALSE) A. The R_CONSTRAINT_NAME column gives the alternative name for the constraint.
-> R_CONSTRAINT_NAME: Name of the unique constraint definition for referenced table
(TRUE) B. In the second column, ‘c’ indicates a check constraint.
(FALSE)C. The STATUS column indicates whether the table is currently in use.
-> STATUS : Enforcement status of constraint (ENABLED or DISABLED)
(TREU) 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.