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

  1. Question 1: Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)
  2. Question 2: A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (…
  3. Question 3: Which statement about NOT ENFORCED unique constraints is TRUE?
  4. Question 4: A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running t…
  5. Question 5: Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
  6. Question 6: Which statement about label-based access control (LBAC) is TRUE?
  7. Question 7: A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES…
  8. Question 8: Which of the following are valid Explain operators? (Choose two.)
  9. Question 9: Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
  10. Question 10: Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?