READ Free Dumps For IBM- A2090-612
| Question ID 22410 | Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and |
| Option A | NUMTCB parameter must be set to 1 for Java stored procedures. |
| Option B | NUMTCB parameter must be set to 1 for REXX stored procedures. |
| Option C | NUMTCB parameter can be a value greater than 1 for native SQL stored procedures. |
| Option D | NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities. |
| Correct Answer | B |
| Question ID 22411 | If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is |
| Option A | The next sort step will perform two sorts. |
| Option B | There are multiple sorts in the plan step. |
| Option C | One sort in the plan step will accomplish two tasks. |
| Option D | Two sorts are performed on the new table of a star join. |
| Correct Answer | C |