Category: 000-611 Real Tests (May 2017)

Ensurepass2017 May IBM Official New Released 000-611 Q&As100% Free Download! 100% Pass Guaranteed!http://www.ensurepass.com/000-611.htmlDB2 10.1 DBA for Linux, UNIX, and Windows QUESTION 61 What information can be obtained by analyzing EXPLAIN data?   A. Access type, index use, and work load B. Index use, work load, and join methods C. Work load, access type, and join methods D. Join methods, index use, and access type   Correct Answer: D     QUESTION 62 How Read more [...]

Ensurepass2017 May IBM Official New Released 000-611 Q&As100% Free Download! 100% Pass Guaranteed!http://www.ensurepass.com/000-611.htmlDB2 10.1 DBA for Linux, UNIX, and Windows QUESTION 51 Which statement is true regarding client-server database connectivity?   A. A remote connection uses Interprocess Communication (IPC). B. A loopback connection can be made with either the APPC or TCP/IP protocol enabled. C. A remote connection is established between a DB2 client in a different Read more [...]

Ensurepass2017 May IBM Official New Released 000-611 Q&As100% Free Download! 100% Pass Guaranteed!http://www.ensurepass.com/000-611.htmlDB2 10.1 DBA for Linux, UNIX, and Windows QUESTION 31 Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?   A. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE; ALTER TABLESPACE my_ts REBALANCE; B. ALTER Read more [...]

Ensurepass2017 May IBM Official New Released 000-611 Q&As100% Free Download! 100% Pass Guaranteed!http://www.ensurepass.com/000-611.htmlDB2 10.1 DBA for Linux, UNIX, and Windows QUESTION 41 Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)   A. The table is not a system temporary table. B. The table contains a sufficient amount of data. C. A table-level compression dictionary Read more [...]

Ensurepass2017 May IBM Official New Released 000-611 Q&As100% Free Download! 100% Pass Guaranteed!http://www.ensurepass.com/000-611.htmlDB2 10.1 DBA for Linux, UNIX, and Windows QUESTION 11 If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?   A. Self-tuning is occurring only on the instance memory area. B. The memory tuner is actively tuning the memory on the system. C. Self-tuning is not occurring because Read more [...]

Ensurepass2017 May IBM Official New Released 000-611 Q&As100% Free Download! 100% Pass Guaranteed!http://www.ensurepass.com/000-611.htmlDB2 10.1 DBA for Linux, UNIX, and Windows QUESTION 21 Which of the following table types is NOT supported by the load utility?   A. A Temporal table B. A Range Partitioned table C. A Global Temporary table D. A Multidimensional Clustering table   Correct Answer: C   QUESTION 22 Which data movement utility is suitable for moving and Read more [...]

Ensurepass2017 May IBM Official New Released 000-611 Q&As100% Free Download! 100% Pass Guaranteed!http://www.ensurepass.com/000-611.htmlDB2 10.1 DBA for Linux, UNIX, and Windows QUESTION 1 Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command can be used to recover the database and repair the corruption Read more [...]