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

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

Contribute your Thoughts:

Submit Cancel

Tanesha

21 days ago

Wait, is this a trick question? I bet the real answer is 'all of the above and more' - the Teradata query planning ecosystem is a rabbit hole!

upvoted 0 times

...

Lawana

23 days ago

Hmm, I'm not sure about E. Isn't nz_plan more for plan analysis rather than just getting the plan file?

upvoted 0 times

Blondell

2 days ago

A) nzsql -c \'show planfile \'

upvoted 0 times

...

Christiane

29 days ago

I'm not sure about the commands. Can someone explain why A) and B) are the correct options?

upvoted 0 times

...

Brunilda

1 months ago

I think D and E are also valid options. Those nz_* commands are often used for plan management.

upvoted 0 times

Otis

23 days ago

C) nzsql -c \'get planfile \'

upvoted 0 times

...

Agustin

25 days ago

B) nzsql -c \'select plan_text from _v_plan\'

upvoted 0 times

...

Harrison

26 days ago

A) nzsql -c \'show planfile \'

upvoted 0 times

...

Van

1 months ago

I agree with Leah. Those commands make sense for getting a plan file for a query.

upvoted 0 times

...

Leah

1 months ago

I think the correct commands are A) nzsql -c 'show planfile ' and B) nzsql -c 'select plan_text from _v_plan'.

upvoted 0 times

...

Shayne

2 months ago

I'd go with B and C. Querying the plan metadata table is the standard approach.

upvoted 0 times

Gilberto

27 days ago

Yeah, that's the standard approach for getting a plan file for a query.

upvoted 0 times

...

Jules

29 days ago

I agree, querying the plan metadata table is the way to go.

upvoted 0 times

...

Dana

2 months 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

Iluminada

8 days ago

Exactly, using those commands will give you access to the plan file directly from the system catalog.

upvoted 0 times

...

Argelia

11 days ago

Great, so both B and C can be used to get the plan file for a query.

upvoted 0 times

...

Latonia

1 months ago

Yes, that's correct. C) nzsql -c \'get planfile \' is also a valid option to retrieve the plan file.

upvoted 0 times

...

Dorthy

1 months ago

I think B) nzsql -c \'select plan_text from _v_plan\' is the right command to get the plan file.

upvoted 0 times

...