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)- A16% (8)
- B71% (35)
- C4% (2)
- D8% (4)
Community Discussion
No community discussion yet for this question.