最新的IBM DB2 10 DBA for z/OS - C2090-612免費考試真題

A. The first part of the data is stored in the base table and second part is stored in the auxiliary table.

B. The data is only stored in the base table.

C. The complete data is storedboth in auxiliary and in base table.

D. The data is only stored in the auxiliary table.

A. DSSIZEcannot be altered.

B. Universal table space.

C. XML table space.

D. Segmented table space.

A. To choose a clustering index to favor batch sequential processing.

B. To choose a clustering index to promote sequential inserts at the end of the table space.

C. To increase free space.

D. Because the clusteringindex has to match the primary index.

A. Start accounting class 7 & 8 traces.

B. Start a monitor class 1 & 2 trace.

C. Start a statistics class 1 trace.

D. Start an audit class 3 trace.

A. DECIMAL (31,18)

B. INTEGER

C. DECFLOAT (34)

D. BIGINT

A. An auxiliary index.

B. An XML index.

C. A user defined catalog index.

D. An index defined with BUSINESS_TIME WITHOUT OVERLAPS.

A. General information needed for recovery.

B. Information about currently runningand stopped copy jobs.

C. Only information about existing image copies.

D. Only information about objects which are currently in copy pending.

A. Partition-by-growth table space.

B. Range-partitioned tablespace.

C. Segmented table space.

D. LOB table space.