READ Free Dumps For IBM- A2090-612
| Question ID 22416 | When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more |
| Option A | List prefetch |
| Option B | Dynamic prefetch |
| Option C | Sequential prefetch |
| Option D | Skip sequential prefetch |
| Correct Answer | B |
| Question ID 22417 | In order to retain an access path across a rebind which of the following commands could be used? |
| Option A | BIND PLAN |
| Option B | REBIND PACKAGE(PK1) REOPT(ONCE) |
| Option C | BIND PACKAGE (PK1) EXPLAIN(YES) |
| Option D | REBIND PACKAGE (PK1) PLANMGMT(BASIC) |
| Correct Answer | D |