Leads4pass > IBM > IBM Certified Database Administrator > C2090-311 > C2090-311 Online Practice Questions and Answers

C2090-311 Online Practice Questions and Answers

Questions 4

How is the Query Workload Tuner license installed and enabled?

A. With Data Studio, using the license activation kit.

B. By executing the db2licm command after data server installation.

C. With the Optim Performance Manager Server, using the license activation kit.

D. By running the Query Workload Tuner license activation command on the appropriate WebSphere server.

Buy Now
Questions 5

If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?

A. -1

B. 1

C. ON

D. ANY

Buy Now
Questions 6

By default, the Optim Workload Table Organization Advisor will recommend converting row- organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?

A. 15 percent

B. 20 percent

C. 25 percent

D. 30 percent

Buy Now
Questions 7

Which two sources can be used to provide input to the InfoSphere Optim Query Workload Tuner that generate EXPLAIN information when creating the query workload?

A. db2pd

B. Routines

C. EXPLAIN tables

D. Snapshot monitor

E. ACTIVITIES event monitors

Buy Now
Questions 8

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

Buy Now
Questions 9

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.

Buy Now
Questions 10

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.

Buy Now
Questions 11

What are the correct steps to capture EXPLAIN information for column-organized tables?

A. 1. Issue the query against column-organized tables

2. Execute the db2exfmt command

B. 1. Execute the command CURRENT EXPLAIN MODE YES

2.

Issue the query against column-organized tables

3.

Execute the db2exfmt command

C. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES

2.

Issue the query against column-organized tables

3.

Execute the db2exfmt command

D. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES

2.

Execute the command CURRENT EXPLAIN MODE YES

3.

Issue the query against column-organized tables

4.

Execute the db2exfmt command

Buy Now
Questions 12

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

Buy Now
Questions 13

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.

Buy Now
Exam Code: C2090-311
Exam Name: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1
Last Update: Dec 16, 2024
Questions: 30
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$49.99

VCE

$55.99

PDF + VCE

$65.99