AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-146





Question ID 2777

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.)
 

Option A

A.    LAST and COUNT give different values.
 

Option B

B.    LAST and COUNT give the same values.
 

Option C

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

Option D

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

Correct Answer A,C
Explanation


Question ID 2778

Which two statements are true about associative arrays and varrays? (Choose two.)
 

Option A

A.    Only varrays must use sequential numbers as subscripts.
 

Option B

B.    Only varrays can be used as column types in database tables.
 

Option C

C.    Both associative arrays and varrays must use sequential numbers as subscripts.
 

Option D

D.    Both associative arrays and varrays can be used as column types in database tables.
 

Correct Answer A,B
Explanation

Send email to admin@getfreedumps for new dumps request!!!