nerdexam
IBM

C2090-610 · Question #88

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…

The correct answer is A. 1) Create a primary key on table TAB1. See the full explanation below for the reasoning.

Question

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?

Options

  • A
    1. Create a primary key on table TAB1;
  • B
    1. Create a primary key on table TAB2;
  • C
    1. Create a primary key on table TAB1;
  • D
    1. Create a primary key on table TAB2;

How the community answered

(30 responses)
  • A
    77% (23)
  • B
    7% (2)
  • C
    13% (4)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice