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

• Question 91:

  Which statement describes a way to minimize the impact of a RUNSTATS operation?

  A. Reduce I/O by using a shadow table space for statistics collection.

  B. Execute the RUNSTATS command with the WITH DISTRIBUTION option specified.

  C. Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified.

  D. Limit the number of pages and rows processed by using page-level or row-level table sampling.

  Correct Answer: D

• Question 92:

  If the following command is executed:

  

  Which statement is true?

  A. Rejected records will be inserted into the table SCHEMA2.E1

  B. Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.

  C. While the Load is executing, other transactions can both read and write into table SCHEMA6.T1

  D. If using a remote database connection, the file "/mnt/datafile.del" must be accessible to the database server host.

  Correct Answer: A

• Question 93:

  Which statement describes adaptive row compression?

  A. Adaptive compression allows for use of customized compression dictionary creation algorithms.

  B. Adaptive compression maintains a dynamic and ever changing table-level row compression dictionary.

  C. Adaptive compression incorporates both classic table-level row compression and page-by-page based row compression.

  D. Adaptive compression incorporates four compression approaches: tablespace-level, table-level, page-level, and bufferpool-level.

  Correct Answer: C

• Question 94:

  What does the FLUSH PACKAGE CACHE statement do?

  A. It removes all dynamic SQL statements from the package cache.

  B. It removes only inactive SQL statements from the package cache.

  C. It saves dynamic SQL stored in the package cache to an external file.

  D. It causes all SQL statements in the package cache that are currently in use to be recompiled.

  Correct Answer: A

• Question 95:

  The following commands are executed against a database named MY_DB, which has been configured to use archival logging:

  

  Which statement is true?

  A. Upon completion of the Load, the table T1 is placed into "Backup Pending" state.

  B. Upon completion of the Load, a backup image of table T1 is automatically generated.

  C. After a Restore and Rollforward operation, table T1 would be marked unavailable and can only be dropped.

  D. After a Restore and Rollforward operation, the loaded data is stored into a copy-image file and table T1 is fully available.

  Correct Answer: C

• Question 96:

  Which statement about updating index statistics with the RUNSTATS command is true?

  A. It requires a full index scan.

  B. It can be accomplished by sampling the index.

  C. It must be executed against all indexes for the table.

  D. It cannot be accomplished without scanning the associated table.

  Correct Answer: B

• Question 97:

  What authorization is needed to execute the CREATE MASK statement?

  A. SECADM

  B. SQLADM

  C. SYSADM

  D. SYSCTRL

  Correct Answer: A

• Question 98:

  Which statement is correct for a user who holds SECADM authority?

  A. A user who holds SECADM authority can only grant and revoke database object privileges.

  B. A user who holds SECADM authority can grant and revoke all database level authorities and database object privileges.

  C. A user who holds SECADM authority can only grant and revoke DBADM and SECADM database level authorities.

  D. A user who holds SECADM authority can only grant and revoke label based access control (LBAC) security labels.

  Correct Answer: B

• Question 99:

  Which of the following table types is NOT supported by the load utility?

  A. A Temporal table

  B. A Range Partitioned table

  C. A Global Temporary table

  D. A Multidimensional Clustering table

  Correct Answer: C

• Question 100:

  Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?

  A. INGEST

  B. REPLICATION

  C. LOAD WITH READ ACCESS

  D. IMPORT WITH BUFFERED INSERT

  Correct Answer: A