IBM Exam C1000-085 Topic 8 Question 73 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 73
Topic #: 8

[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

by Sharmaine at Oct 24, 2024, 02:03 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

23 hours ago

I see your point, but I still think A) makes more sense because it specifically mentions 'show planfile'

upvoted 0 times

...

1 days ago

Options B and C look like the correct answers. I think the 'show planfile' and 'get planfile' commands are the ones used to retrieve the plan file.

upvoted 0 times

...

3 days ago

I disagree, I believe the correct answer is B) nzsql -c 'select plan_text from _v_plan'

upvoted 0 times

...

4 days ago

I think the answer is A) nzsql -c 'show planfile '

upvoted 0 times

...