C2090-600

C2090-600 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