Oracle
1Z0-882 · Question #52
1Z0-882 Question #52: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #52. The question stem and answer options stay visible for context.
Question
The contents of the parent and child tables are: The child table has the parent_id column that has a foreign key constraint to the id column of the parent table with ON DELETE CASCADE clause. Consider the command WHERE id =1; What is the effect of the above command?
Options
- AIt does not delete anything from any table but returns an error.
- BIt deletes one row from the parent table but does not affect the child table.
- CIt deletes one row from the parent table and two rows from the child table.
- DIt deletes one row from the parent table and sets the parent _id column to NULL in the child.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 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.