Oracle
1Z0-047 · Question #160
1Z0-047 Question #160: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #160. The question stem and answer options stay visible for context.
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.)
Exhibit
Options
- AIn the second column, 'C' indicates a check constraint.
- BThe STATUS column indicates whether the table is currently in use.
- CThe R_CONSTRAINT_NAME column gives the alternative name for the constraint.
- DThe column DELETE_RULE decides the state of the related rows in the child table when the corresponding
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.