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

Which statement about column-organized tables is true?

A. Databases with column-organized tables can be federated.

B. Schemas that include column-organized tables can be transported.

C. Sort memory can be automatically tuned in environments containing column-organized tables.

D. Queries that use the Currently Committed semantics can be used with column-organized tables.

Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?

A. db2iupdt-a

B. db2iupdt-update

C. db2iupdt-commit_level

D. db2iupdt-online_update

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.

Which statement about expression-based indexes is true?

A. The RUNSTATS command cannot be used to collect statistics for expression-based indexes.

B. Expression-based indexes must always be defined as UNIQUE to prevent duplicate index keys.

C. Expression-based index keys consist of a concatenation of one or more specified table columns.

D. The index key values of expression-based indexes are not the same as the values in the corresponding table columns.

An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created for a table named EMPLOYEE.

If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:

RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE ONLY

Which command will create a statistics profile on the EMPLOYEE table?

A. RUNSTATS ON TABLE employee USE PROFILE

B. RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1

C. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL

D. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1 GENERATE PROFILE

If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two capabilities are available?

A. Multi-tenancy

B. Workload consolidation

C. Independent tuning member

D. Broadcasting STMM tuning decisions to all members

E. Single INSTANCE_MEMORY instance configuration memory setting

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.

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.