IBM
000-611
DB2 10.1 DBA for Linux, UNIX, and Windows
Click the link below to buy full version as Low as $25 http://www.examkill.com/000-611.html
ExamKill is team of experienced and educated professionals working day and night to develop preparation material for different fields in IT. These industries are including HP, IBM, Comptia, Orcale, Apple, Adobe, Nortel, Novell, Checkpoint etc with the following features.
Free Samples:
Free samples download are available for almost every product to check before
buy.
Complete Course Coverage: Experienced professionals are making sure to cover complete course so that you pass final exam.
Updated Material: Preparation material is updated and new; you can compare us with other providers in the same industry.
Privacy Protection:
Examkill team makes sure not to reveal your private information
including your credit card and other secret information.
Excellent Customer Support: You will get reply from examkill support within 8 hours for all your questions/concerns about anything.
www.examkill.com
Question: 1 Which statement is true regarding the workload management dispatcher? A. The workload management dispatcher monitors work performed by entities executing in the DB2 system service class. B. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system. C. The workload management dispatcher monitors non-DB2 work performed in fenced mode processes such as fenced stored procedures. D. The workload management dispatcher monitors work performed by applications or middleware products that perform a portion of their work outside of the DB2 database manager.
Answer: B Question: 2 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
Answer: D Question: 3 How is the time that an agent waits for log records to be flushed to disk calculated? A. LOG_END_TIME divided by TOTAL_COMMITS B. LOG_WAIT_TIME divided by TOTAL_COMMITS C. LOG_WRITE_TIME divided by TOTAL_COMMITS D. LOG_FLUSH_TIME divided by TOTAL_COMMITS
Answer: C Question: 4 Which tool should be used to collect data during a potential hang without stopping the database manager?
http://www.examkill.com/000-611.html
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper
2
A. db2ls B. db2dart C. db2fodc D. db2cklog
Answer: C Question: 5 Which action can a DBA take to retrieve bufferpool metrics information? A. Ensure the MON_OBJ_METRICS configuration parameter is enabled and query the BP_HITRATIO table function. B. Ensure the MON_ACT_METRICS configuration parameter is enabled and query the BP_HITRATIO administrative view. C. Ensure the MON_OBJ_METRICS configuration parameter is enabled and query the MON_GET_BUFFERPOOL table function. D. Ensure the MON_ACT_METRICS configuration parameter is enabled and query the MON_GET_BUFFERPOOL administrative view.
Answer: C Question: 6 Which tool should be used to give you lock wait information from the DB2 memory sets? A. db2pd B. db2mtrk C. db2fodc D. db2support
Answer: A Question: 7 A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC STORAGE NO What is the recommended way to convert the database MYDB to an automatic storage database?
http://www.examkill.com/000-611.html
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper
3
A. Use the ALTER DATABASE statement to add storage paths to the database. B. Use the CREATE STOGROUP statement to define a new storage group in the database and to assign storage paths to the new storage group. C. Use the UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC STORAGE configuration parameter for the database to YES. D. Use the DROP DATABASE command to drop the database; then, recreate the database by executing a CREATE DATABASE command statement that does not contain the AUTOMATIC STORAGE NO option.
Answer: B Question: 8 Which statement about insert time clustering tables (ITC) is true? A. ITC tables cannot be range-partitioned tables. B. ITC tables are supported in DB2 pureScale environments. C. Rows of an ITC table are clustered by the time they are inserted into the table. D. If an ITC table is clustered by one or more user specified dimensions, the specified dimensions must be timestamps.
Answer: C
http://www.examkill.com/000-611.html
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper
4
IBM
000-611
DB2 10.1 DBA for Linux, UNIX, and Windows
Click the link below to buy full version as Low as $25
http://www.examkill.com/000-611.html
We also provide PDF Training Material for: Hot Exam 000-188
000-582
000-N07
00M-240
000-N07
00M-220
000-281
000-582
00M-249
00M-646
000-068
000-036
00M-228
00M-602
000-M95
000-030
000-178
000-219
000-608
000-556
00M-245
00M-237
000-230
000-601
000-533
000-609
LOT-921
COG-632
http://www.examkill.com/000-611.html
www.examkill.com
Adobe Apple Cisco CompTIA HP EMC IBM Microsoft Oracle Juniper
5