nerdexam
IBM

C2090-312 · Question #69

In which situation does adding a referential constraint place a table space containing data into check-pending status?

The correct answer is B. When a foreign key is defined on a table with the ENFORCED option. See the full explanation below for the reasoning.

Question

In which situation does adding a referential constraint place a table space containing data into check-pending status?

Options

  • AWhen a primary key is defined on a table with no unique index.
  • BWhen a foreign key is defined on a table with the ENFORCED option.
  • CWhen a foreign key is defined on a table and a corresponding primary key has not been defined.
  • DWhen a foreign key is defined on a table with NOT ENFORCED option and a unique index has

How the community answered

(49 responses)
  • A
    16% (8)
  • B
    71% (35)
  • C
    4% (2)
  • D
    8% (4)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice