READ Free Dumps For IBM- 000-611
| Question ID 19937 | Which statement about updating index statistics with the RUNSTATS command is true? |
| Option A | It requires a full index scan. |
| Option B | It can be accomplished by sampling the index. |
| Option C | It must be executed against all indexes for the table. |
| Option D | It cannot be accomplished without scanning the associated table. |
| Correct Answer | B |
| Question ID 19938 | What can be used to provide input to the Design Advisor? |
| Option A | An XML file. |
| Option B | A query workload file. |
| Option C | The database configuration file. |
| Option D | The database manager configuration file. |
| Correct Answer | B |