IBM

C2090-312 · Question #107

How do you enable parallelism in a dynamic SQL statement?

The correct answer is C. Use SET CURRENT DEGREE = ANY. See the full explanation below for the reasoning.

Question

How do you enable parallelism in a dynamic SQL statement?

Options

ABIND with DEGREE(1)
BBIND with DEGREE(ANY)
CUse SET CURRENT DEGREE = ANY
DUse SET CURRENT DEGREE = '1'

How the community answered

(26 responses)

A
12% (3)
B
4% (1)
C
77% (20)
D
8% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-312 Practice