IBM Exam C1000-085 Topic 5 Question 83 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 83
Topic #: 5

[All C1000-085 Questions]

Which two commands can be used to get a plan file for a query?

Anzsql -c 'show planfile '

Bnzsql -c 'select plan_text from _v_plan'

Cnzsql -c 'get planfile '

Dnz_get

Enz_plan

Show Suggested Answer

Suggested Answer: A, D

by Tori at Jun 12, 2025, 12:29 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

B and C seem to be the correct options. Getting the plan file directly from the system catalog is the way to go.

upvoted 0 times

...