Oracle Exam 1Z0-149 Topic 14 Question 7 Discussion

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

Question #: 7
Topic #: 14

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: D

by Kristeen at Apr 01, 2023, 01:54 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!