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 2789

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


Question ID 2790

Examine the structure of the PRINT_MEDIA table:
Name Null? Type    
        

ADVT_ID NUMBER ADVT_SOURCE CLOB
Examine the following PL/SQL block:
DECLARE
lobloc CLOB;
buffer VARCHAR2(100);
amount NUMBER;
offset NUMBER :=1;
BEGIN
buffer :='This is the second line of a new document';
amount := LENGTH(buffer);
SELECT advt_source INTO lobloc FROM print_media WHERE advt_id=2 FOR UPDATE;
DBMS_LOB.WRITE(lobloc,amount,offset,buffer);
successfully?

Option A

A.    null
 

Option B

B.    an empty locator
 

Option C

C.    a non-NULL value
 

Option D

D.    either null or any non-NULL values
 

Correct Answer C
Explanation

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