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 = ORDERSWhich 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.
Evaluate the following SELECT statement and view the Exhibit to examine its output:SELECT constraint_name, constraint_ty
-
- Site Admin
- Posts: 899558
- Joined: Mon Aug 02, 2021 8:13 am