Oracle Exam 1Z0-149 Topic 13 Question 15 Discussion

Actual exam question for Oracle's 1Z0-149 exam

Question #: 15
Topic #: 13

[All 1Z0-149 Questions]

Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

AIn line 1, change IN OUT mode to IN mode.

BIn line 2, change IN OUT mode to IN mode.

CIn line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.

DIn line 1, add the default parameter DEFAULT 2000.

EIn line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.

FIn line 2, add the default parameter DEFAULT 2000.

Show Suggested Answer

Suggested Answer: A, D

https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm

by Lavonna at Oct 21, 2023, 08:57 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-149 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Stephaine

2 months ago

Ah, the old 'IN OUT vs IN' mode switcheroo. Classic Oracle exam question. I bet the developers were having a field day when they wrote this one.

upvoted 0 times

Adell

22 hours ago

I'm pretty sure it's A) and F)

upvoted 0 times

...

Karol

2 days ago

No, I believe it's C) and E)

upvoted 0 times

...

Lizette

3 days ago

I think the correct answers are A) and B)

upvoted 0 times

...

Ciara

2 months ago

This is a tricky one, but I think C and F are the way to go. Updating the query condition and adding a default parameter for the second parameter should do the trick. Piece of cake!

upvoted 0 times

Lashaun

13 days ago

Great, those changes should ensure that PDT_REPORT executes successfully.

upvoted 0 times

...

Leanna

22 days ago

I agree, and I also think F is needed to add a default parameter for the second parameter.

upvoted 0 times

...

Lucy

23 days ago

I think C is correct because we need to replace CUR_PRICE with P_PDT_PRICE in the query condition.

upvoted 0 times

...

Kenneth

2 months ago

Hmm, I'm leaning towards A and C. Adjusting the parameter mode and the query condition should address the issues here. Fingers crossed!

upvoted 0 times

Una

1 months ago

User4: Good luck with that!

upvoted 0 times

...

Edwin

1 months ago

User3: Let's hope for the best!

upvoted 0 times

...

Ling

1 months ago

User2: Agreed, changing the parameter mode and query condition should do the trick.

upvoted 0 times

...

Brett

2 months ago

User1: I think A and C are the way to go.

upvoted 0 times

...

Fatima

2 months ago

Ah, I see. B and C should do the trick. Changing the IN OUT mode to IN mode on line 2 and updating the query condition will make this thing run smoothly.

upvoted 0 times

Alida

27 days ago

Agreed, those changes should make it work.

upvoted 0 times

...

Honey

28 days ago

B and C should work.

upvoted 0 times

...

Jess

29 days ago

User 2: Agreed, those changes should make it work.

upvoted 0 times

...

Tanja

2 months ago

User 1: I think B and C are the way to go.

upvoted 0 times

...

Nida

2 months ago

I think option C is the way to go. Replacing CUR_PRICE with P_PDT_PRICE in the query condition seems like the logical fix to execute PDT_REPORT successfully.

upvoted 0 times