File Info
| Exam | IBM DB2 11.1 DBA for LUW |
| Number | C2090-600 |
| File Name | IBM.C2090-600.ActualTests.2019-08-20.37q.vcex |
| Size | 176 KB |
| Posted | Aug 20, 2019 |
| Download | IBM.C2090-600.ActualTests.2019-08-20.37q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which of the following are all valid types of trigger?
- AFTER, ATOMIC, BEFORE
- AFTER, ATOMIC, INSTEAD OF
- AFTER, BEFORE, INSTEAD OF
- 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?
- UPDATE DB CFG USING MON_OBJ_METRICS BASE
- UPDATE DB CFG USING MON_ACT_METRICS BASE
- UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
- UPDATE MONITOR SWITCHES USING BUFFERPOOL ON
Correct answer: C
Question 3
What levels of authority are needed to create a storage group? (Choose two.)
- DBADM
- SYSADM
- SQLADM
- SYSCTRL
- 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.)
- XML
- BLOB
- CLOB
- VARCHAR
- DATETIME
Correct answer: DE
Question 5
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)
- XML
- REAL
- NUMBER
- VRCHAR2
- 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?
- SYNC
- ASYNC
- NEARSYNC
- SUPERASYNC
Correct answer: D
Question 7
Which statement about Data Server Manager (DSM) is TRUE?
- DSM can be used for reviewing audit trails
- DSM cannot be used for database administration
- DSM can be used for configuration management of DB2 Data Server drivers
- 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.)
- You can change the principal standby of the primary without first stopping HADR on the primary.
- The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.
- You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.
- You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.
- You cannot remove a standby from the list if it is connected to the primar
- To disconnect a standby, simply deactivate i
- 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?
- db2look
- db2advis
- db2expln
- db2exfmt
Correct answer: C
Question 10
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
- When the registry variableDB2_AUTORECLAIMSPACE=YES
- After termination all the back-end processes using TERMINATE command
- After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
- When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation
Correct answer: C
