File Info
| Exam | IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 |
| Number | C2090-311 |
| File Name | IBM.C2090-311.TestKing.2019-02-20.30q.tqb |
| Size | 193 KB |
| Posted | Feb 20, 2019 |
| Download | IBM.C2090-311.TestKing.2019-02-20.30q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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
