IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows - 000-614 Exam Practice Test
Which statement about compression dictionaries is FALSE?
Correct Answer: C
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
A DBA wants to create a table named SALES that has the following characteristics:
- Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21. - Data for the second half of the year will reside in table space TBSP2; the index for this data will reside in table space TBSP22.
Which clause must be used with the CREATE TABLE statement to define this table?
- Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21. - Data for the second half of the year will reside in table space TBSP2; the index for this data will reside in table space TBSP22.
Which clause must be used with the CREATE TABLE statement to define this table?
Correct Answer: C
Vote an answer
Where is the HADR_TARGET_LIST configuration parameter set?
Correct Answer: B
Vote an answer
Which statement about data type mappings is true in a federated system?
Correct Answer: B
Vote an answer
With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?
Correct Answer: C
Vote an answer
A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON ?db2fs1? ?db2fs2? '/db2fs3' Then, a table space named TS1 was created in the storage group and two tables (TAB_A and TAB_B) were created in the TS1 table space. Four months later, a DBA discovered that 90% of the space that had been allocated to the MED_SG storage group had been consumed. So, more space was added to the storage group by executing the following command: ALTER STOGROUP med_sg ADD ?db2fs4? ALTER STOGROUP med_sg ADD ?db2fs4 Shortly afterwards, queries against tables in the TS1 table space began to run slower. Which statement should be executed to correct the performance problem?
Correct Answer: C
Vote an answer
Which command(s) should be used to drop database partition 10 from a database named MYDB?
Correct Answer: D
Vote an answer