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 1645

Evaluate this IF statement: value > 100 THEN

v_new_value := 2 * v_value;

v_new_value := 3 * v_value;

ELSIF vvalue < 300 THEN

v_new_value := 4 * v_value;

ELSE

v_new_value := 5 * v_value;

END IF;

What would be assigned to V_NEW_VALUE if V_VALUE is 250?

Option A

A.    250
 

Option B

B.    500
 

Option C

C.    1250
 

Option D

D.    750

 

Option E

E.    1000

Correct Answer B
Explanation


Question ID 1646

Examine the code:
SET SERVEROUTPUT ON
DECLARE
v_name emp.ename%TYPE;
v_num NUMBER;
v_sal NUMBER(8,2);
BEGIN
-- This code displays salaries if larger than 10000
SELECT ename, sal
 
INTO v_name, v_sal
FROM emp
WHERE empno = 101;
IF (v_sal .GT. 10000) THEN
DBMS_OUTPUT.PUT_LINE ('Salary is ' || v_sal
|| ' for employee ' || v_name);
END IF;
END;
SET SERVEROUTPUT OFF
Which statement causes a compilation error when the above PL/SQL block is executed?
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Option A

A.    SELECT ename, sal INTO v_name, v_sal FROM emp
WHERE empno = 101;
 

Option B

B.    IF (v_sal .GT. 10000) THEN
 

Option C

C.    v_name emp.ename%TYPE;
 

Option D

D.    v_num NUMBER;

 

Option E

E.    -- This code displays salaries if larger than 10000

Correct Answer B
Explanation

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