IBM C2090-600 Exam Questions Instant Access

Question 1

If the following SQL statements are executed:

How many rows will be added to the DEPARTMENT table?

Answer : D

Question 2

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?

AREORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;

BREORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;

CRUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;

DRUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Answer : A

Question 3

Which options are valid for an online reorganization operation?

AFULL and RECLAIM EXTENTS

BCLASSIC and RECLAIM EXTENTS

CFULL and CLEANUP OVERFLOWS

DCLEAN OVERFLOWS and RECLAIM EXTENTS

Answer : A

Question 4

Which DB2 Explain Facility tool uses the Explain tables to display access plain information?

Adb2look

Bdb2advis

Cdb2expln

Ddb2exfmt

Answer : C

Question 5

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

AUPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

BUPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

CCONNECT TO sample;UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;

DATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

Answer : C

Question 6

Which statement regarding event monitors is TRUE?

AEvent monitor data can be reviewed while the event monitor is active

BEvent monitors must always be started manually after activating a database

CEvent monitors must write data to .EVT files before the data can be loaded into database tables

DEvent monitors are used to obtain information about how a database system looks at a specific point in time

Answer : B

Question 7

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.

Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

AREORG TABLE sales INPLACE RESETDICTIONARY

BREORG TABLE sales INPLACE REBUILDDICTIONARY

CREORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY

DREORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

Answer : C

IBM DB2 11.1 DBA for LUW C2090-600 Exam Questions