Free IBM C2090-600 Exam Dumps Questions & Answers


Exam Code/Number:	C2090-600Join the discussion
Exam Name:	IBM DB2 11.1 DBA for LUW
Certification:	IBM
Free Question Number:	60
Publish Date:	Jul 13, 2026
# of views:	2804
Rating 100%

Page: 1 / 12
Total 60 questions

Question 1

Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

A.NUMBER
B.REAL
C.XML
D.VRCHAR2
E.VARBINARY

Question 2

Which of the following are all valid types of trigger?

A.AFTER, ATOMIC, BEFORE
B.AFTER, BEFORE, INSTEAD OF
C.ATOMIC, BEFORE, INSTEAD OF
D.AFTER, ATOMIC, INSTEAD OF

Question 3

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

A.REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND IN DEXES ALL;
B.REORG TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;
C.RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;
D.RUNSTATS ON TABLE sales IN PLACE AND INDEXES ALL;

Question 4

Which options are valid for an online reorganization operation?

A.CLASSIC and RECLAIM EXTENTS
B.FULL and RECLAIM EXTENTS
C.CLEAN OVERFLOWS and RECLAIM EXTENTS
D.FULL and CLEANUP OVERFLOWS

Question 5

What levels of authority are needed to create a storage group? (Choose two.)

A.SYSADM
B.SYSMAINT
C.DBADM
D.SYSCTRL
E.SQLADM