Practice questions

Question 1

Which statement regarding the CHECK constraint is TRUE?

1. The CHECK constraint is supported in both row-organized and column-organized tables.
2. A table can have only one CHECK constraint defined.
3. When there are some rows that do not meet the CHECK constraint, the CHECK constraint can still be created.
4. The ALTER TABLE statement can be used to define a CHECK constraint on an existing table.

Question 2

What are NOT ENFORCED informational constraints used for?

1. To influence the Db2 optimizer data access plan during referential integrity constraint enforcement.
2. To influence the Db2 optimizer data access plan for the SELECT operation without impacting the INSERT and UPDATE operations.
3. To influence the Db2 optimizer to use the primary key index during the SELECT operation.
4. To influence the Db2 optimizer to always cache the data in the buffer pool for faster...