C2090-311 Online Practice Questions and Answers

If the DB2_WORKLOAD registry variable has not been set which database manager configuration parameter must be modified, before a query that accesses a column-organized table can be executed?

A. INTRA_PARALLEL

B. QUERY_HEAP_SZ

C. MAXIMUM DEGREE

D. SHEAPTHRES SHR

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 command, when executed, will enable workload management for column-organized table

workloads?

A. db2setDB2_WORKLOAD=ANALYTICS

B. db2set DB2_WLM_DISP_CONCUR=START

C. UPDATE DBM CFG USING WLM_DISPATCHER YES

D. UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL

Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?

A. EHL is enabled by default in DB2 10.5 pureScale environments.

B. There are three EHL states available: SHARED, DIRECT_ACCESS and NONSHARED.

C. Only regular tables, temporary tables, and non-partitioned indexes can take advantage of EHL.

D. EHL is designed to improve DB2 pureScale performance by avoiding CF communications for tables that are accessed from only one member.

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.

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

Which monitoring function can be used to determine how many times an SQL statement has referenced a particular column-organized table within a specific period of time?

A. MON_GET_TABLE()

B. MON_GET_TABLESPACE()

C. MON_GET_UNIT_OF_WORK()

D. MON_GET_TABLE_USAGE_LIST()

Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?

A. Row compression

B. Index compression

C. Backup compression

D. Temporary table compression

Which scenario does NOT require intraquery parallelism?

A. The execution of the LOAD command against an empty column-organized table.

B. A DML operation that references a populated column-organized table.

C. The execution of the RUNSTATS command against a populated column-organized table.

D. The addition of a primary key constraint to an empty column-organized table.