IBM Exam C1000-085 Topic 7 Question 74 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 74
Topic #: 7

[All C1000-085 Questions]

Which two commands will show a query plan without running the query?

Anz_plan querytext

BEXPLAIN PLAN FILE querytext

CEXPLAIN PLANGRAPH querytext

DEXPLAIN querytext

Enzsql -t querytext -0 planfile.pln

Show Suggested Answer

Suggested Answer: C

by Lauran at Nov 18, 2024, 06:40 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

10 days ago

Hmm, I think options C and D are the way to go. EXPLAIN PLANGRAPH and EXPLAIN should both show the query plan without actually running the query.

upvoted 0 times

...

29 days ago

But B) EXPLAIN PLAN FILE querytext specifically mentions showing the query plan without running the query.

upvoted 0 times

...

30 days ago

I disagree, I believe the correct answer is D) EXPLAIN querytext.

upvoted 0 times

...

1 months ago

I think the answer is B) EXPLAIN PLAN FILE querytext.

upvoted 0 times

...