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.