Oracle
1Z0-071 · Question #138
1Z0-071 Question #138: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #138. The question stem and answer options stay visible for context.
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.)
Exhibit
Options
- AThe DELETE_RULE column indicates the desired state of related rows in the child table when the
- BThe R_CONSTRAINT_NAME column contains an alternative name for the constraint.
- CIn the second column, 'c' indicates a check constraint.
- DThe STATUS column indicates whether the table is currently in use.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.