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

Get Premium C1000-085 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Miles

8 days ago

Ah, the age-old dilemma of planning versus execution. I'm going with C and D, the EXPLAIN commands, to get the plan without the performance hit.

upvoted 0 times

...

Jose

9 days ago

Haha, I'm going to go with C and D just to be safe. Who needs to actually run the query when you can just look at the plan, am I right?

upvoted 0 times

...

Eliseo

13 days ago

Ah, this is a tricky one! I'm going to go with C and D. EXPLAIN PLANGRAPH and EXPLAIN seem like the most logical choices to view the plan without running the query.

upvoted 0 times

...

Alison

17 days ago

I'm pretty sure the correct answers are C and D. EXPLAIN PLANGRAPH and EXPLAIN are the commands that will display the query plan without executing the query.

upvoted 0 times

...