READ Free Dumps For IBM- C2090-311
| Question ID 20881 | In which type of database are column-organized tables supported? |
| Option A | Partitioned databases. |
| Option B | DB2 pureScale databases. |
| Option C | Databases whose code set is Unicode. |
| Option D | Databases whose code set is Non-Unicode. |
| Correct Answer | A |
| Question ID 20882 | What are the correct steps to capture EXPLAIN information for column-organized tables? |
| Option A | 1. Issue the query against column-organized tables 2. Execute the db2exfmt command |
| Option B | 1. Execute the command CURRENT EXPLAIN MODE YES 2. Issue the query against column-organized tables 3. Execute the db2exfmt command |
| Option C | 1. Set the ENABLE_COLUMN_TABLES registry variable to YES 2. Issue the query against column-organized tables 3. Execute the db2exfmt command |
| Option D | 1. Set the ENABLE_COLUMN_TABLES registry variable to YES 2. Execute the command CURRENT EXPLAIN MODE YES 3. Issue the query against column-organized tables 4. Execute the db2exfmt command |
| Correct Answer | D |