READ Free Dumps For IBM- A2090-612
| Question ID 22414 | When is a merge scan join a well performing access path? |
| Option A | When the number of qualifying rows of the inner and outer table are both large. |
| Option B | When the query references at least two dimensions and the STARJOIN subsystem parameter is 1. |
| Option C | When the number of rows in the outer table is small and the number of pages accessed in the inner table is |
| Option D | When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate |
| Correct Answer | A |
| Question ID 22415 | What trace class will show deadlock information? |
| Option A | Audit class 3. |
| Option B | Statistic class 3. |
| Option C | Accounting class 1. |
| Option D | Performance class 8. |
| Correct Answer | B |