Free A2090-614 Questions for IBM Assessment: DB2 10.1 Advanced DBA for LUW A2090-614 Exam as PDF & Practice Test Engine
The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for optimal query performance?
Correct Answer: B
Vote an answer
After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool would you use to determine which LOAD operation is being problematic?
Correct Answer: D
Vote an answer
What can be done to prevent applications from failing when DB2 cannot create a new log file?
Correct Answer: C
Vote an answer
The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?
Correct Answer: D
Vote an answer
If a large amount of sequential prefetching is occurring, what can be done to improve efficiency?
Correct Answer: D
Vote an answer
What are two supported methods for providing a low latency, high speed interconnect between DB2 members and the cluster caching facility (CF) in a DB2 pureScale environment? (Choose two.)
Correct Answer: A,B
Vote an answer
Which diagnostic tool can be used to collect metrics on individual SQL statement executions?
Correct Answer: D
Vote an answer
What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)
Correct Answer: B,D
Vote an answer
0
0
0
10