Free 1Z0-882 Web TestEngine Demo

Q4 Single choice

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?

A
It does not delete anything from any table but returns an error.
B
It deletes one row from the parent table but does not affect the child table.
C
It deletes one row from the parent table and two rows from the child table.
D
It deletes one row from the parent table and sets the parent_id column to NULL in the child.

1Z0-882 Web TestEngine demo