User USER1 wants to define a required relationship between two tables named TAB1 and TAB2
in such a way that whenever a record is deleted from table TAB1, any related records are deleted
from table TAB2. What must user USER1 do to accomplish this?
A.
1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE CASCADE rule.
B.
1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE CASCADE rule.
C.
1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE RESTRICT rule.
D.
1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE RESTRICT rule.
Explanation: