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

  1. Question 11: The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows in…
  2. Question 12: If the following SQL statements are executed: CREATE DATABASE testdb AUTOMATIC STORAGE NO; CONNECT TO testdb; CREATE STOGROUP sg1 ON /data1; CREATE STOGROUP ib…
  3. Question 13: Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPL…
  4. Question 14: Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?
  5. Question 15: When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0,…
  6. Question 16: Which of the following statements about compression for BLU MPP tables is TRUE?
  7. Question 17: What is an advantage of using range partitioned tables?
  8. Question 18: Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?
  9. Question 19: Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?
  10. Question 20: Which options are valid for an online reorganization operation?