Download IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1.C2090-311.BrainDumps.2018-06-20.15q.vcex

Vendor: IBM
Exam Code: C2090-311
Exam Name: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1
Date: Jun 20, 2018
File Size: 11 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
Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?
  1. db2iupdt-a
  2. db2iupdt-update
  3. db2iupdt-commit_level
  4. db2iupdt-online_update
Correct answer: B
Question 2
What is a DB2 Advanced Copy Services (ACS) script used for?
  1. To install and configure DB2 Advanced Copy Services.
  2. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services.
  3. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.
  4. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACS API vendor library.
Correct answer: C
Question 3
Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?
  1. SYNC
  2. ASYNC
  3. NEARSYNC
  4. SUPERSYNC
  5. SUPERASYNC
Correct answer: BC
Question 4
Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?
  1. EHL is enabled by default in DB2 10.5 pureScale environments.
  2. There are three EHL states available: SHARED, DIRECT_ACCESS and NONSHARED.
  3. Only regular tables, temporary tables, and non-partitioned indexes can take advantage of EHL.
  4. EHL is designed to improve DB2 pureScale performance by avoiding CF communications for tables that are accessed from only one member.
Correct answer: A
Question 5
What will cause the creation of a column-organized table to fail?
  1. Setting the database code set to UNICODE.
  2. Setting the DFT_DEGREE database configuration parameter to ANY.
  3. Setting the AUTO_RUNSTATS database configuration parameter to ON.
  4. Setting the UTILJHEAP_SZ database configuration parameter to at least 1.000,000 pages.
Correct answer: C
Question 6
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.
Correct answer: D
Question 7
In which type of database are column-organized tables supported?
  1. Partitioned databases.
  2. DB2 pureScale databases.
  3. Databases whose code set is Unicode.
  4. Databases whose code set is Non-Unicode.
Correct answer: A
Question 8
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 9
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
Question 10
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
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!