Oracle Exam 1Z0-149 Topic 2 Question 16 Discussion

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

Question #: 16
Topic #: 2

Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /

Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

AIt will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

BIt will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

CIt will fail at lines 6 and 7.

DIt will fail only at line 7.

Show Suggested Answer

Suggested Answer: A, E

by Kallie at Nov 21, 2023, 11:12 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sang

2 months ago

I'm stumped! This question is making my brain hurt. Guess I'll have to go with my gut and choose option C. *sigh*

upvoted 0 times

...

Cornell

2 months ago

I bet the exam writers were chuckling when they came up with this one. Option C is the way to go, folks!

upvoted 0 times

Catarina

14 days ago

I'm not sure about the others, but I'm confident that option C is the right choice.

upvoted 0 times

...

Octavio

19 days ago

Yeah, I agree. The anonymous block will definitely fail at lines 6 and 7.

upvoted 0 times

...

Carlee

1 months ago

I think option C is correct because the anonymous block will fail at lines 6 and 7.

upvoted 0 times

...

Lottie

2 months ago

Oh, this one's tricky! I'm going with option D - the code will fail only at line 7 because PriceList is not defined as an associative array.

upvoted 0 times

Dannette

1 months ago

Yeah, I agree. The code will fail only at line 7 because PriceList is not defined as an associative array.

upvoted 0 times

...

Lanie

1 months ago

I think you're right, option D seems like the correct choice.

upvoted 0 times

...

Lauran

2 months ago

Yeah, I agree. The code will fail only at line 7 because PriceList is not defined as an associative array.

upvoted 0 times

...

Veda

2 months ago

I think you're right, option D seems to be the correct choice.

upvoted 0 times

...

Colene

2 months ago

Interesting question! I think option C is the correct answer. The issue is that PriceList is not defined as a collection type in the DECLARE section, so the code will fail on lines 6 and 7.

upvoted 0 times

...

Kirk

2 months ago

The anonymous block will fail at lines 6 and 7 because PriceList is not defined as a collection type in the DECLARE section.

upvoted 0 times

...

Sylvie

2 months ago

Hmm, that makes sense too. I guess we need to carefully consider the data types in the code.

upvoted 0 times

...

Clay

2 months ago

I disagree, I believe the correct answer is B because PriceList should be defined as an associative array.

upvoted 0 times

...

Sylvie

3 months ago

I think the correct answer is A because PriceList needs to be removed from the DECLARE section.

upvoted 0 times

...