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 1609

You want to create a report that gives, per department, the number of employees and total salary as a percentage of all the departments.
Examine the results from the report: Department %Employees %Salary
10 21.43 30.15 2
0 35.71 37.47
30 42.86 32.39
Which SELECT statement produces the report?

Option A

A.    SELECT deptno "Department",
(COUNT(*)/COUNT(empno)) * 100 "%Employees", (SUM(sal)/COUNT(*)) * 100 "%Salary"
FROM scott.emp
GROUP BY deptno;
 

Option B

B.    SELECT
a.deptno "Department",
ROUND(a.num_emp/b.total_count * 100, 2) "%Employees",
 
ROUND(a.sal_sum/b.total_sal * 100, 2) "%Salary"
FROM
(SELECT deptno, COUNT(*) num_emp, SUM(SAL) sal_sum
FROM scott.emp
GROUP BY deptno) a,
(SELECT COUNT(*) total_count, SUM(sal) total_sal
FROM scott.emp) b;
 

Option C

C.    SELECT deptno "Department",
PCT(empno) "%Employees",
PCT(sal) "%Salary" FROM scott.emp GROUP BY deptno;
 

Option D

D.    SELECT a.deptno "Department",
(a.num_emp/COUNT(*)) * 100 "%Employees", (a.sal_sum/COUNT(*)) * 100 "%Salary"
FROM
(SELECT deptno, COUNT(*) num_emp, SUM(SAL) sal_sum FROM scott.emp
GROUP BY deptno) a;
 

Correct Answer B
Explanation


Question ID 1610

Which privilege concerns system level security?

Option A

A.    INDEX
 

Option B

B.    DROP ANY TABLE
 

Option C

C.    DELETE
 

Option D

D.    UPDATE

 

Option E

E.    ALTER

Correct Answer B
Explanation

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