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.)

Question

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.)

Accepted Answer

A. The DELETE_RULE column indicates the desired state of related rows in the child table when the C. In the second column, 'c' indicates a check constraint.

Answer

B. The R_CONSTRAINT_NAME column contains an alternative name for the constraint.

Answer

D. The STATUS column indicates whether the table is currently in use.

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…

Question

Exhibit

Options

How the community answered

Community Discussion