READ Free Dumps For IBM- C2090-612
| Question ID 20500 | For which table type could you specify ALTERTABLE tb1 DATA CAPTURE CHANGES? |
| Option A | Catalog tables |
| Option B | Directory tables |
| Option C | Auxiliary tables |
| Option D | Declared global temporary tables |
| Correct Answer | A |
| Question ID 20501 | What two parameters allow DB2to keep a copy of a dynamically prepared statement in the |
| Option A | KEEPDYNAMIC(YES) and CACHEDYN=YES |
| Option B | KEEPDYNAMIC(NO) and CACHEDYN=NO |
| Option C | KEEPDYNAMIC(NO) and REOPT(ALWAYS) |
| Option D | KEEPDYNAMIC(YES) and REOPT(ALWAYS) |
| Correct Answer | A |