PrepAway - Latest Free Exam Questions & Answers

What must user USER1 do to accomplish this?

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply