Download IBM DB2 11.1 DBA for LUW.C2090-600.ActualTests.2019-08-20.37q.vcex

Vendor: IBM
Exam Code: C2090-600
Exam Name: IBM DB2 11.1 DBA for LUW
Date: Aug 20, 2019
File Size: 176 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 of the following are all valid types of trigger?
  1. AFTER, ATOMIC, BEFORE
  2. AFTER, ATOMIC, INSTEAD OF
  3. AFTER, BEFORE, INSTEAD OF
  4. ATOMIC, BEFORE, INSTEAD OF
Correct answer: C
Question 2
When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?
  1. UPDATE DB CFG USING MON_OBJ_METRICS BASE
  2. UPDATE DB CFG USING MON_ACT_METRICS BASE
  3. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
  4. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON
Correct answer: C
Question 3
What levels of authority are needed to create a storage group? (Choose two.)
  1. DBADM
  2. SYSADM
  3. SQLADM
  4. SYSCTRL
  5. SYSMAINT
Correct answer: BD
Question 4
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)
  1. XML
  2. BLOB
  3. CLOB
  4. VARCHAR
  5. DATETIME
Correct answer: DE
Question 5
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)
  1. XML
  2. REAL
  3. NUMBER
  4. VRCHAR2
  5. VARBINARY
Correct answer: CE
Question 6
An HADR environment has two standby databases – one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?
  1. SYNC
  2. ASYNC
  3. NEARSYNC
  4. SUPERASYNC
Correct answer: D
Question 7
Which statement about Data Server Manager (DSM) is TRUE?
  1. DSM can be used for reviewing audit trails
  2. DSM cannot be used for database administration
  3. DSM can be used for configuration management of DB2 Data Server drivers
  4. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue
Correct answer: D
Question 8
The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)
  1. You can change the principal standby of the primary without first stopping HADR on the primary.
  2. The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.
  3. You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.
  4. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.
  5. You cannot remove a standby from the list if it is connected to the primar
  6. To disconnect a standby, simply deactivate i
  7. The you can remove it from the primary’s target list.
Correct answer: AE
Question 9
Which DB2 Explain Facility tool uses the Explain tables to display access plain information?
  1. db2look
  2. db2advis
  3. db2expln
  4. db2exfmt
Correct answer: C
Question 10
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
  1. When the registry variableDB2_AUTORECLAIMSPACE=YES
  2. After termination all the back-end processes using TERMINATE command
  3. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
  4. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation
Correct answer: C
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!