IBM C1000-085 Exam - 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

Glory

2 months ago

I thought nzsql was the only way to go.

upvoted 0 times

...

Simona

2 months ago

Definitely A and E!

upvoted 0 times

...

Evangelina

3 months ago

I think B is also valid, right?

upvoted 0 times

...

Denna

3 months ago

Wait, is nz_get even a real command?

upvoted 0 times

...

Rashida

3 months ago

A and C are correct commands!

upvoted 0 times

...

Cruz

3 months ago

I definitely recall nz_plan being mentioned in our study materials, but I can't remember if it's the right one for this question.

upvoted 0 times

...

Truman

3 months ago

I’m a bit confused; I thought nz_get was used for something else. Is it really an option here?

upvoted 0 times

...

Noah

4 months ago

I remember practicing with similar commands, and I feel like option C could be correct too.

upvoted 0 times

...

Raymon

4 months ago

I think option A sounds familiar, but I'm not completely sure about the syntax.

upvoted 0 times

...

Anna

4 months ago

I've seen this type of question before. I'm pretty confident I know the right commands to use, but I'll carefully consider each option to make sure I don't miss anything.

upvoted 0 times

...

Shaniqua

4 months ago

The key here is identifying the correct SQL commands that can be used to access the plan file. I'll review the options and try to eliminate the ones that don't seem right.

upvoted 0 times

...

Lindsey

5 months ago

I'm a bit confused by the wording of this question. Can the plan file be retrieved using a SELECT statement or do we need to use a specific command?

upvoted 0 times

...

Gail

5 months ago

Okay, I think I know the answer to this one. Let me double-check the options and make sure I'm not missing anything.

upvoted 0 times

...

Lon

5 months ago

Hmm, this looks like a tricky one. I'll need to think carefully about the different SQL commands that could be used to get a plan file.

upvoted 0 times

...

Tanesha

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

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

Sonia

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

...

Myra

6 months ago

D) nz_get

upvoted 0 times

...

Lenna

6 months ago

C) nzsql -c \'get planfile \'

upvoted 0 times

...

Leanora

7 months ago

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

upvoted 0 times

...

Blondell

7 months ago

A) nzsql -c \'show planfile \'

upvoted 0 times

...

Christiane

8 months ago

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

upvoted 0 times

...

Brunilda

8 months ago

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

upvoted 0 times

Otis

8 months ago

C) nzsql -c \'get planfile \'

upvoted 0 times

...

Agustin

8 months ago

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

upvoted 0 times

...

Harrison

8 months ago

A) nzsql -c \'show planfile \'

upvoted 0 times

...

Van

8 months ago

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

upvoted 0 times

...

Leah

8 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

8 months ago

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

upvoted 0 times

Gilberto

8 months ago

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

upvoted 0 times

...

Jules

8 months ago

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

upvoted 0 times

...

Dana

9 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

7 months ago

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

upvoted 0 times

...

Argelia

7 months ago

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

upvoted 0 times

...

Latonia

8 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

8 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

...