Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-311
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-311.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:

Ensurepass 2018 PDF and VCE

Which SQL statement will fail?

Ensurepass 2018 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% Ensurepass Free Download!
Download Free Demo:C2090-311 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-311 Dumps

EnsurePass 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.