C2090-600: IBM DB2 11.1 DBA for LUW

C2090-600: IBM DB2 11.1 DBA for LUW practice questions, page 3 of 3, with answer review and explanations.

Question 11

Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

  1. When the registry variable DB2_AUTORECLAIMSPACE=YES
  2. After termination all the back-end processes using TERMINATE command
  3. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
  4. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

Question 12

Which security mechanism is responsible for verifying that users are indeed who the claim to be?

  1. Authentication
  2. Roles and privileges
  3. Mandatory access control
  4. Discretionary access control