Examine this SELECT statement and view the Exhibit to see its output: 

SELECT constraints_name, constraints_type, search_condition, r_constraints_name, delete_rule, status, FROM user_constraints - WHERE table_name = `ORDERS`; Which two statements are true about the output? (Choose two.) 

Answer options:

A. The DELETE_RULE column indicates the desired state of related rows in the child table when the corresponding row is deleted from the parent table.
B. The R_CONSTRAINT_NAME column contains an alternative name for the constraint.
C. In the second column, `c` indicates a check constraint.
D. The STATUS column indicates whether the table is currently in use.

AC