When defining a foreign key on a table, which statement is true?

Question

Options

• AIt is not mandatory to have an index on the foreign key columns but it can help to avoid locking
• BThere is no need to define an index on the foreign key columns as DB2 cannot use an index for
• CIt is not mandatory to have an index on the foreign key columns but it can help performance when
• DYou must define an index on the foreign key columns where the index columns are the same as

• A
  76% (26)
• B
  6% (2)
• C
  15% (5)
• D
  3% (1)

No community discussion yet for this question.