Download IBM.C2090-600.ActualTests.2019-08-20.37q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-600 |
| Exam Name: | IBM DB2 11.1 DBA for LUW |
| Date: | Aug 20, 2019 |
| File Size: | 279 KB |
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
