Oracle
1Z0-062 · Question #208
1Z0-062 Question #208: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #208. The question stem and answer options stay visible for context.
Question
The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMETS .DEPARTMENT_ID column. An index exists on the DEPARTMETS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table. Which statement is true?
Options
- AThe transaction acquires a table lock only on the DEPARTMENTS table until the transaction is
- BOnly the rows that are deleted in the DEPARTMETS and EMPLOYEES tables are locked until the
- CThe transaction acquires a table lock only on the DEPARTMENTS table. This lock enables other
- DThe transaction acquires a table lock only on the EMPLOYEES table. This lock enables other
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 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.