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 1591

The structure of the DEPT table is as follows:
Name Null? Type
DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14)
LOC VARCHAR2(13)
Examine the code:
DECLARE
dept_rec dept%ROWTYPE;
BEGIN
SELECT *
INTO dept_rec
FROM dept
WHERE deptno = 10;
END;
Which PL/SQL statement displays the location of the selected department?
 

Option A

A.    DBMS_OUTPUT.PUT_LINE (dept_rec.loc);
 

Option B

B.    DBMS_OUTPUT.PUT_LINE (dept_rec);
 

Option C

C.    You cannot display a single field in the record because they are not explicitly identified in the declarative section.

 

Option D

D.    DBMS_OUTPUT.PUT_LINE (dept_rec(1).loc);

Correct Answer A
Explanation


Question ID 1592

Which SELECT statement displays employee names, salaries, department numbers, and average salaries for all employees who earn more than the average salary in their department?

Option A

A.    SELECT outer.ename,outer.sal,outer.deptno,AVG(outer.sal)
FROM emp outer
GROUP BY outer.ename, outer.sal, outer.deptno
HAVING AVG(outer.sal) IN
(SELECT inner.sal
FROM emp inner
WHERE inner.deptno = outer.deptno);
 

Option B

B.    SELECT outer.ename,outer.sal,
outer.deptno,AVG(outer.sal)
FROM emp outer
GROUP BY outer.ename, outer.sal, outer.deptno
HAVING AVG(outer.sal) >
(SELECT inner.sal
FROM emp inner WHERE inner.deptno = outer.deptno);
 

Option C

C.    SELECT ename, sal, deptno, AVG(sal) FROM emp
GROUP BY ename, sal, deptno;

 

Option D

D.    SELECT a.ename, a.sal, a.deptno, b.salavg
FROM emp a, (SELECT deptno, AVG(sal) salavg
FROM emp
GROUP BY deptno) b
WHERE a.deptno = b.deptno
AND a.sal > b.salavg;

Correct Answer D
Explanation

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