IBM

A2090-560 · Question #91

Given a plan ID, how would you obtain the query execution plan? (Choose two.)

The correct answer is C. Go to the query history within the Windows NzAdmin GUI tool. E. Issue "SHOW PLANFILE <nn>;" after the query has been submitted. See the full explanation below for the reasoning.

Question

Given a plan ID, how would you obtain the query execution plan? (Choose two.)

Options

ATurn ODBC tracing ON.
BIssue "SELECT * FROM _V_SESSION;"
CGo to the query history within the Windows NzAdmin GUI tool.
DRun EXECUTION PLAN before the query has been submitted.
EIssue "SHOW PLANFILE <nn>;" after the query has been submitted.

How the community answered

(35 responses)

A
3% (1)
B
14% (5)
C
77% (27)
D
6% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full A2090-560 Practice