IBM C2090-600 Exam Practice Test Instant Access

Question 1

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 2

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

ADBADM

BSYSADM

CSQLADM

DSYSCTRL

ESYSMAINT

Answer : B, D

Question 3

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

AXML

BREAL

CNUMBER

DVRCHAR2

EVARBINARY

Answer : C, E

Question 4

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 5

Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

ATo prunethe contents of a staging table.

BTo prune the contents of a synopsis table.

CTo prune the contents of a materialized query table (MQT).

DTo prune the contents of a declared global temporary table.

Answer : A

Question 6

Which of the following statements about compression for BLU MPP tables is TRUE?

ACompression must be explicitly enabled for BLU MPP tables

BCompression requires decompression to evaluate partition joins

CUnique compression dictionaries are generated for each partition

DEach table has a single compression dictionary that getsreplicated across all partitions

Answer : D

Question 7

If the following SQL statements are executed:

How many rows will be added to the DEPARTMENT table?

Answer : D

IBM C2090-600 IBM DB2 11.1 DBA for LUW Exam Practice Test