Exit 1Z0-146 Oracle Database 11g: Advanced PL/SQL
Question 4 of 5
0% complete
Q4 Multiple choice

Examine the code in the following PL/SQL block:

DECLARE

TYPE NumList IS TABLE OF INTEGER;

List1 NumList := NumList(11,22,33,44);

BEGIN

List1.DELETE(2);
DBMS_OUTPUT.PUT_LINE

( 'The last element# in List1 is ' || List1.LAST ||

' and total of elements is '||List1.COUNT);

List1.EXTEND(4,3);

END;

/

Which two statements are true about the above code? (Choose two.)

Select all that apply.

  • A

    LAST and COUNT give different values.

  • B

    LAST and COUNT give the same values.

  • C

    The four new elements that are added contain the value 33.

  • D

    The four new elements that are added contain the value 44.