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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |