Free C2090-611 Questions for IBM DB2 10.1 DBA for Linux, UNIX, and Windows C2090-611 Exam as PDF & Practice Test Engine
By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?
Correct Answer: B
Vote an answer
A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?
Correct Answer: C
Vote an answer
Which High Availability Disaster Recovery (HADR) synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?
Correct Answer: B
Vote an answer
Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)
Correct Answer: C,D
Vote an answer
What authority must be held to create a trusted context?
Correct Answer: A
Vote an answer
If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?
Correct Answer: B
Vote an answer
What authorization is needed to use the AUDIT statement to create an audit policy?
Correct Answer: A
Vote an answer
0
0
0
10