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 2857

Examine the structure of the TEXT_TAB table.
Name Null? Type    
        

TEXT_ID NUMBER
DOC1 CLOB
DOC2 CLOB
You issue the following INSERT commands:
INSERT INTO text_tab VALUES (1, 'This is line 1',null);
INSERT INTO text_tab VALUES (2, 'This is line 1','This is line 2');
Then you execute the following block of the PL/SQL code:
DECLARE
vc1 VARCHAR2(1000):= 'This is the preface';
lb1 CLOB;
lb2 CLOB;
BEGIN
SELECT doc1 INTO lb1 FROM text tab WHERE text_id=1;
SELECT doc1 || doc2 INTO lb1 FROM text_tab WHERE text_id=2;
lb2 := vc1|| lb1;
UPDATE text_tab SET doc2 = lb2 WHERE text_id = 1;
END;
/
What is the outcome?
 

Option A

A.    It executes successfully.
 

Option B

B.    It gives an error because VARCHAR2 should be explicitly converted to CLOB.
 

Option C

C.    It gives an error because CLOB variables should be initialized to EMPTY_CLOB().
 
 

Option D

D. It gives an error because the concatenation operator cannot be used with the CLOB data type. 
 

Correct Answer A
Explanation


Question ID 2858

In which two situations is the body of a result-cached function executed? (Choose two.)
 

Option A

A.    if the memory allocated for the result cache is increased
 

Option B

B.    if a session on this database instance invokes the function with the same parameter values
 

Option C

C.    if the first time a session on this database instance invokes the function with a parameter value
 

Option D

D.    if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function
 

Correct Answer C,D
Explanation

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