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 4 of 6.

1. Question 34: You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility…
2. Question 35: Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?
3. Question 36: Which of the following statements is TRUE?
4. Question 37: Which of the following statements about audit policies is TRUE?
5. Question 38: What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?
6. Question 39: Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)
7. Question 40: What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?
8. Question 41: Which statement about the db2move command is TRUE?
9. Question 42: An HADR environment has two standby databases one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?
10. Question 43: Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?