Oracle Database 19c: Program with PL/SQL 1z0-149 Question # 8 Topic 1 Discussion

Oracle Database 19c: Program with PL/SQL 1z0-149 Question # 8 Topic 1 Discussion

1z0-149 Exam Topic 1 Question 8 Discussion:
Question #: 8
Topic #: 1

Examine these statements issued by user SH which execute successfully:

1z0-149 Question 8

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

Now, examine this anonymous block executed by SH:

1z0-149 Question 8

Which is true about the anonymous block?


A.

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


B.

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


C.

It will fail at lines 6 and 7.


D.

It will fail only at line 7.


Get Premium 1z0-149 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.