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 1573

Examine this block of code:
SET SERVEROUTPUT ON DECLARE
x NUMBER;
v_sal NUMBER;
v_found VARCHAR2(10) := 'TRUE'; BEGIN
x := 1;
v_sal := 1000;
DECLARE
v_found VARCHAR2(10);
y NUMBER;
BEGIN
IF (v_sal > 500) THEN
v_found := 'YES';
END IF;
DBMS_OUTPUT.PUT_LINE ('Value of v_found is '|| v_found);
DBMS_OUTPUT.PUT_LINE ('Value of v_sal is '|| v_sal);
y := 20; END; DBMS_OUTPUT.PUT_LINE ('Value of v_found is '|| v_found); DBMS_OUTPUT.PUT_LINE ('Value of Y is '|| TO_CHAR(y)); END; SET SERVEROUTPUT OFF
Why does this code produce an error when executed?

Option A

A.    The value of V_FOUND cannot be 'YES'.
 

Option B

B.    Variable Y is declared in the inner block and referenced in the outer block.
 

Option C

C.    Variable V_FOUND is declared at more than one location.

 

Option D

D.    Variable V_SAL is declared in the outer block and referenced in the inner block.

Correct Answer B
Explanation


Question ID 1574

Click on the EXHIBIT button and examine the table instance chart for the employee table.
You want to display each employee's hire date from earliest to latest. Which SQL statement would you use?

Option A

A.    SELECT hire_date

FROM employee;

Option B

B.    SELECT hire_date

FROM employee

ORDER BY hire _date DESC;

Option C

C.    SELECT hire date

FROM employee ORDER BY hire date;

Option D

D.    SELECT hire date

FROM employee GROUP BY hire _date;

Correct Answer C
Explanation

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