IBM
C2090-312 · Question #196
When defining a check constraint on a populated table and the value of the special register CURRENT RULES is 'DB2'. What is the result of executing the DDL statement?
The correct answer is B. The table space is placed in CHKP status. See the full explanation below for the reasoning.
Question
When defining a check constraint on a populated table and the value of the special register CURRENT RULES is 'DB2'. What is the result of executing the DDL statement?
Options
- AIt is rejected by the database system.
- BThe table space is placed in CHKP status.
- CIt is checked against only all existing rows in the table.
- DIt is checked against only new rows as they are added to the table.
How the community answered
(46 responses)- A13% (6)
- B76% (35)
- C4% (2)
- D7% (3)
Community Discussion
No community discussion yet for this question.