Download IBM.C2090-311.TestKing.2019-02-20.30q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-311 |
| Exam Name: | IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 |
| Date: | Feb 20, 2019 |
| File Size: | 193 KB |
Demo Questions
Question 1
How is the Query Workload Tuner license installed and enabled?
- With Data Studio, using the license activation kit.
- By executing the db2licm command after data server installation.
- With the Optim Performance Manager Server, using the license activation kit.
- By running the Query Workload Tuner license activation command on the appropriate WebSphere server.
Correct answer: A
Question 2
If the DB2_WORKLOAD registry variable has not been set which database manager configuration parameter must be modified, before a query that accesses a column-organized table can be executed?
- INTRA_PARALLEL
- QUERY_HEAP_SZ
- MAXIMUM DEGREE
- SHEAPTHRES SHR
Correct answer: A
Question 3
If the following commands are executed successfully:
Which SQL statement will fail?
- Option A
- Option B
- Option C
- Option D
Correct answer: C
