READ Free Dumps For IBM- 000-611
| Question ID 19939 | Which statement describes a way to minimize the impact of a RUNSTATS operation? |
| Option A | Reduce I/O by using a shadow table space for statistics collection. |
| Option B | Execute the RUNSTATS command with the WITH DISTRIBUTION option specified. |
| Option C | Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified. |
| Option D | Limit the number of pages and rows processed by using page-level or row-level table sampling. |
| Correct Answer | D |
| Question ID 19940 | If the following command is executed:
Which statement is true? |
| Option A | Rejected records will be inserted into the table SCHEMA2.E1 |
| Option B | Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load. |
| Option C | While the Load is executing, other transactions can both read and write into table SCHEMA6.T1 |
| Option D | If using a remote database connection, the file "/mnt/datafile.del" must be accessible to the database |
| Correct Answer | A |
