IBM C2090-612 Certification Practice Questions & Answers

Question 6 of 134

When is a merge scan join a well performing access path?

A.

When the number of qualifying rows of the inner and outer table are both large.

B.

When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.

C.

When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.

D.

When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.

Question 7 of 134

What trace class will show deadlock information?

A.

Audit class 3.

B.

Statistic class 3.

C.

Accounting class 1.

D.

Performance class 8.

Question 8 of 134

Which DSNZPARM will define the number of RID Blocks in the RID Pool?

A.

NUMTCB

B.

MAXRBLK

C.

CONDBAT

D.

URLGWTH

Question 9 of 134

When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?

A.

List prefetch

B.

Dynamic prefetch

C.

Sequential prefetch

D.

Skip sequential prefetch

Question 10 of 134

In order to retain an access path across a rebind which of the following commands could be used?

A.

BIND PLAN

B.

REBIND PACKAGE(PK1) REOPT(ONCE)

C.

BIND PACKAGE (PK1) EXPLAIN(YES)

D.

REBIND PACKAGE (PK1) PLANMGMT(BASIC)