[Free] 2017(Oct) CollectDumps Testinsides IBM C2090-311 V13 Dumps with VCE and PDF Download 11-20

CollectDumps 2017 Oct IBM Official New Released C2090-311 V13
100% Free Download! 100% Pass Guaranteed!
http://www.CollectDumps.com/C2090-311 V13.html

IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

Question No: 11

When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width size for database tables?

  1. 32 KB

  2. 64 KB

  3. 1MB

  4. 2 MB

Answer: B

Question No: 12

How is the Query Workload Tuner license installed and enabled?

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

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

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

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

Answer: A

Question No: 13

Which statement about expression-based indexes is true?

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

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

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

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

Answer: D

Question No: 14

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

  1. Multi-tenancy

  2. Workload consolidation

  3. Independent tuning member

  4. Broadcasting STMM tuning decisions to all members

  5. Single INSTANCE_MEMORY instance configuration memory setting

Answer: D,E

Question No: 15

If the following commands are executed successfully:

Collectdumps 2017 PDF and VCE

Which SQL statement will fail?

Collectdumps 2017 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: C

Question No: 16

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

  1. -1

  2. 1

  3. ON

  4. ANY

Answer: A

Question No: 17

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?

  1. INTRA_PARALLEL

  2. QUERY_HEAP_SZ

  3. MAXIMUM DEGREE

  4. SHEAPTHRES SHR

Answer: A

Question No: 18

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?

  1. RUNSTATS ON TABLE employee USE PROFILE

  2. RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1

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

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

Answer: C

Question No: 19

Which scenario does NOT require intraquery parallelism?

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

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

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

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

Answer: D

Question No: 20

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

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

    2. Execute the db2exfmt command

  2. 1. Execute the command CURRENT EXPLAIN MODE YES

    1. Issue the query against column-organized tables

    2. Execute the db2exfmt command

  3. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES

    1. Issue the query against column-organized tables

    2. Execute the db2exfmt command

  4. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES

  1. Execute the command CURRENT EXPLAIN MODE YES

  2. Issue the query against column-organized tables

  3. Execute the db2exfmt command

Answer: D

100% Free Download!
Download Free Demo:C2090-311 V13 Demo PDF
100% Pass Guaranteed!
Download 2017 CollectDumps C2090-311 V13 Full Exam PDF and VCE

CollectDumps ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 CollectDumps IT Certification PDF and VCE