IBM IBM Certified Advanced Database Administrator C2090-614 Questions & Answers

• Question 81:

  Which category must be enabled before db2audit will record the creation of new buffer pools?

  A. OBJMAINT

  B. SECMAINT

  C. CHECKING

  D. OBJCREATE

  Correct Answer: A

• Question 82:

  What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?

  A. AUDIT

  B. VALIDATE

  C. EXECUTE

  D. CONTEXT

  Correct Answer: C

• Question 83:

  What must you do before an online table space backup operation can be performed?

  A. Create a full database backup image.

  B. Create one or more tables in the table space.

  C. Create an incremental backup image of the table space.

  D. Set the DB2_ENABLE_ONLINEBKUP registry variable to ON.

  Correct Answer: A

• Question 84:

  A table space creation operation was unsuccessful because DB2 failed to allocate a container in a path. Which diagnostic tool can be used to help resolve the problem?

  A. db2dart

  B. db2diag

  C. db2caem

  D. db2fmcu

  Correct Answer: B

• Question 85:

  Which statement about dropped table recovery is correct?

  A. Multiple dropped tables can be recovered with a single table space-level restore operation.

  B. By default, the DROPPED TABLE RECOVERY option is off when a new table space is created.

  C. The dropped table recovery feature lets you recover only dropped table data with a database- level restore operation.

  D. For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.

  Correct Answer: D

• Question 86:

  In which situation would you NOT use a redirected restore?

  A. To redefine the paths of a defined storage group.

  B. To move table space containers onto different physical devices.

  C. To restore a backup image from one operating system to another.

  D. To restore a backup image to a target machine that is different from the source machine.

  Correct Answer: C

• Question 87:

  What is the default user workload class that is created for each database table?

  A. DEFAULT_USER

  B. SYSUSERDEFAULTWLM

  C. SYSDEFAULTUSERWORKLOAD

  D. SYS_DEFAULT_USER_WORKLOAD

  Correct Answer: C

• Question 88:

  Where is the HADR_TARGET_LIST configuration parameter set?

  A. On the primary database only.

  B. On all participating databases.

  C. On the tertiary standby databases.

  D. On the auxiliary standby databases only.

  Correct Answer: B

• Question 89:

  What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)

  A. Table space available space

  B. Table space read and write activity

  C. Table space container assignments

  D. Table level activity within a table space

  E. Table space backup and recovery information

  Correct Answer: AB

• Question 90:

  Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

  A. Data class, work class, and a limit

  B. Data class, action class, and a threshold

  C. Service subclass, action class, and a limit

  D. Service subclass, work class, and a threshold

  Correct Answer: D