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, indicates a check constraint. D. The column DELETE_RULE decides the state of the related rows in the child table when the

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