Prev Question
Next 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.)

5a10498894e64 - Which two statements are true about the output?

In the second column, indicates a check constraint.

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

The R_CONSTRAINT_NAME column gives the alternative name for the constraint.

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.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *