Practice questions

• Question 1: When a new database, SAMPLE, is created after setting the DB2_WORKLOAD to ANALYTICS, which of the following statements are true? (Choose two.)
  1. The degree of parallelism (DFT_DEGREE) will be set to NO
  2. The default tablespace extent size (DFT_EXTENT_SZ) will be set to 4
  3. The default table organization (DFT_TABLE_ORG) will be set to COLUMN
  4. The database page size will be set to 64
  5. The automatic table reorganization (AUTO_REORG) will be set to NO

• Question 2: Which of the following db2cluster command options can be used to retrieve current state and cluster domain information? (Choose two.)
  1. -verify
  2. -extract
  3. -list
  4. -get
  5. -show

• Question 3: When you run the db2convert -d SAMPLE -force command, what will happen to the existing MDC table, SALES?
  1. The SALES table will be converted to a column-organized MDC table
  2. The SALES table will not be converted to...