Download IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1.C2090-311.CertDumps.2016-05-07.30q.vcex

Vendor: IBM
Exam Code: C2090-311
Exam Name: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1
Date: May 07, 2016
File Size: 110 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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
Correct answer: C
Question 2
When does space reclamation for a column-organized table normally occur?
  1. Whenever an individual row is deleted.
  2. Whenever an individual row is updated.
  3. After all rows in an extent have been updated.
  4. After all rows in an extent where updates took place have been deleted.
Correct answer: A
Explanation:
answer is verified.
answer is verified.
Question 3
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
    2. Issue the query against column-organized tables
    3. Execute the db2exfmt command
  3. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES
    2. Issue the query against column-organized tables
    3. Execute the db2exfmt command
  4. 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
Correct answer: D
Question 4
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
Correct answer: DE
Question 5
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?
  1. MON_GET_TABLE()
  2. MON_GET_TABLESPACE()
  3. MON_GET_UNIT_OF_WORK()
  4. MON_GET_TABLE_USAGE_LIST()
Correct answer: A
Question 6
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?
  1. A warning is returned and no statistics are collected.
  2. An error is returned and the table is placed in "load pending" state.
  3. A statistics profile is automatically generated before the load is allowed to continue.
  4. The Load utility uses the same RUNSTATS command options as those used during an automatic
    runstats operation.
Correct answer: C
Question 7
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
Correct answer: B
Question 8
When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?
  1. When crash recovery is occurring on the standby cluster.
  2. When all the log streams are in peer or assisted remote catchup state.
  3. When the primary database is not connected to the standby database.
  4. All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.
Correct answer: D
Question 9
What type of table can be converted into a column-organized table with the db2convert command?
  1. A range partitioned table
  2. A materialized query table
  3. A row-organized user table
  4. A declared global temporary table
Correct answer: A
Question 10
Which statement regarding NOT ENFORCED unique constraints is true?
  1. NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.
  2. The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data access plan.
  3. Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a unique index.
  4. 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.
Correct answer: A
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!