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-001





Question ID 1532

Which two conditions in a PL/SQL block cause an exception to occur? (Choose two.)

Option A

A.    The SELECT statement contains a GROUP BY clause.

 

Option B

B.    The SELECT statement returns more than one row.
 

Option C

C.    The datatypes in the SELECT list are inconsistent with the datatypes in the INTO clause.
 

Option D

D.    The SELECT statement does not return a row.
 

Option E

E.    The SELECT statement does not have a WHERE clause.

Correct Answer B,D
Explanation


Question ID 1533

Examine the code:
1 DECLARE
2 i NUMBER := 0;
3 v_date DATE;
4 BEGIN
5 i := i+1;
6 LOOP
7 v_date := v_date + 5;
8 i := i+1;
9 EXIT WHEN i = 5;
10 END LOOP;
11 END;
You have encountered unexpected results when the above block of code is executed. How can you trace the values of the counter variable I and date variable V_DATE in the SQL*Plus environment?
 

Option A

A.    by inserting the statement
DBMS_OUTPUT.PUT_LINE (i ||' '|| TO_CHAR(v_date)); between lines 8 and 9
 

Option B

B.    by setting the SQL*Plus session variable DEBUGGER = TRUE
 

Option C

C.    by inserting the statement
DBMS_OUTPUT.PUT_LINE (i, v_date); between lines 8 and 9
 

Option D

D.    by inserting the statement
DBMS_OUTPUT.DEBUG_VAR (i, v_date); between lines 8 and 9
 

Correct Answer A
Explanation

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