C2090-311 Online Practice Questions and Answers

If the following commands are executed successfully:

Which SQL statement will fail?

A. Option A

B. Option B

C. Option C

D. Option D

Which type of compression is typically used with column-organized tables?

A. BLU compression

B. Value compression

C. Actionable compression

D. Adaptive row compression

What is a DB2 Advanced Copy Services (ACS) script used for?

A. To install and configure DB2 Advanced Copy Services.

B. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services.

C. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.

D. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACS API vendor library.

What will cause the creation of a column-organized table to fail?

A. Setting the database code set to UNICODE.

B. Setting the DFT_DEGREE database configuration parameter to ANY.

C. Setting the AUTO_RUNSTATS database configuration parameter to ON.

D. Setting the UTILJHEAP_SZ database configuration parameter to at least 1.000,000 pages.

In which type of database are column-organized tables supported?

A. Partitioned databases.

B. DB2 pureScale databases.

C. Databases whose code set is Unicode.

D. Databases whose code set is Non-Unicode.

When does space reclamation for a column-organized table normally occur?

A. Whenever an individual row is deleted.

B. Whenever an individual row is updated.

C. After all rows in an extent have been updated.

D. After all rows in an extent where updates took place have been deleted.

What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to populate a column-organized table and a statistics profile does not exist?

A. A warning is returned and no statistics are collected.

B. An error is returned and the table is placed in "load pending" state.

C. A statistics profile is automatically generated before the load is allowed to continue.

D. The Load utility uses the same RUNSTATS command options as those used during an automatic runstats operation.

When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?

A. When crash recovery is occurring on the standby cluster.

B. When all the log streams are in peer or assisted remote catchup state.

C. When the primary database is not connected to the standby database.

D. All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.

What type of table can be converted into a column-organized table with the db2convert command?

A. A range partitioned table

B. A materialized query table

C. A row-organized user table

D. A declared global temporary table

Which statement regarding NOT ENFORCED unique constraints is true?

A. NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.

B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data access plan.

C. Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a unique index.

D. When attempting to insert data that does not conform to the NOT ENFORCED unique constraint, an error will be returned and the record will not be inserted.