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 1619

Examine the code:
SET SERVEROUTPUT ON
DECLARE
v_char_val VARCHAR2(100);
BEGIN
v_char_val := 'Hello World';
DBMS_OUTPUT.PUT_LINE(v_char_val);
END;
SET SERVEROUTPUT OFF
This code is stored in a script file named myproc.sql. Which statement executes the code in the script file?
 

Option A

A.    EXECUTE myproc.sql
 

Option B

B.    RUN myproc.sql
 

Option C

C.    BEGIN myproc.sql END;
 

Option D

D.    myproc.sql

 

Option E

E.    START myproc.sql

Correct Answer E
Explanation


Question ID 1620

You want to display the average salary for departments 20 and 50, but only if those departments have an average salary of at least 2000. Which statement will produce the required results?

Option A

A.    SELECT deptno, AVG(sal) FROM emp
GROUP BY deptno
HAVING AVG(sal) >= 2000 AND deptno IN (20, 50);
 

Option B

B.    SELECT deptno, AVG(sal) FROM emp
WHERE deptno IN (20, 50) GROUP BY deptno
HAVING AVG(sal) >= 2000;
 

Option C

C.    SELECT deptno, AVG(sal) FROM emp
WHERE deptno IN (20, 50) GROUP BY AVG(sal)
HAVING AVG(sal) >= 2000;
 

Option D

D.    SELECT deptno, AVG(sal) FROM emp
 
WHERE deptno IN (20, 50) AND AVG(sal) >= 2000 GROUP BY deptno;
 

Correct Answer B
Explanation

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