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 2747

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 2748

Which two types of query results cannot be stored in the query result cache? (Choose two.)
 

Option A

A.    subquery results
 

Option B

B.    results of a query having the SYSDATE function
 

Option C

C.    results of a query having the GROUP BY clause

 

Option D

D.    results of a query having the DATE data type in the WHERE clause

Correct Answer A,B
Explanation

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