DB2 10 for z/OS Database Administrator Free Practice Exam Questions

52 real DB2 10 for z/OS Database Administrator exam questions with answers and AI explanations. IBM certification prep — page 5 of 6.

1. Question 44: Where does the DB2 Problem Determination tool (db2pd) get information from?
2. Question 45: Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?
3. Question 46: Which statement regarding event monitors is TRUE?
4. Question 47: When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?
5. Question 48: The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)
6. Question 49: What levels of authority are needed to create a storage group? (Choose two.)
7. Question 50: Which DB2 Explain Facility tool uses the Explain tables to display access plain information?
8. Question 51: You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagno…
9. Question 52: If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?
10. Question 53: Which statement about Data Server Manager (DSM) is TRUE?