READ Free Dumps For IBM- C2090-311
| Question ID 20869 | Which statement regarding NOT ENFORCED unique constraints is true? |
| Option A | NOT ENFORCED unique constraints enforce uniqueness only for primary key columns. |
| Option B | The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data access plan. |
| Option C | Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a unique index. |
| Option D | When attempting to insert data that does not conform to the NOT ENFORCED unique constraint, an error will be returned and the record will not be inserted. |
| Correct Answer | A |
| Question ID 20870 | What happens when the STATISTICS USE PROFILE option is provided with a LOAD |
| Option A | A warning is returned and no statistics are collected. |
| Option B | An error is returned and the table is placed in "load pending" state. |
| Option C | A statistics profile is automatically generated before the load is allowed to continue. |
| Option D | The Load utility uses the same RUNSTATS command options as those used during an automatic runstats operation. |
| Correct Answer | C |