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

Question

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

Accepted Answer

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

Answer

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

Answer

C. The R_CONSTRAINT_NAME column gives the alternative name for the constraint.

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…

Question

Exhibit

Options

How the community answered

Community Discussion