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 8194

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 %SALARY10 21. 4 30. 15 20 35. 71 37. 47 30 42. 86 32. 39 Which select statement produces the report?

Option A

SELECT deptno "department", (COUNT(*)/count(empno))* 100 "%employees", (SUM(sal)/count(*)) * 100 "%salary" FROM scott.emp GROUP BY deptno;

Option B

SELECT deptno "department", PCT(empno) "%employees", PCT(sal) "%salary" FROM scott.emp GROUP BY deptno;

Option C

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;

Option D

SELECT

Option E

deptno. "deparment", ROUND(a.num_emp/b.total_count*100,2) "%employee" 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;

Correct Answer D
Explanation Explanation/Reference: Explanation: Answer D is correct because displayed result shows of usage ROUND function to display two digits after decimal point. Incorrect Answers: A: Result will not be rounded and result itself will be wrong. B: There is no PCT function in Oracle. C: This query uses no ROUND function, so it may be displayed more than two digits after decimal point Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 24-29 Chapter 1: Selecting Data from Oracle


Question ID 8586

Alerts triggered in Cascade Profiler are distributed to recipients by Cascade Profiler using which mechanism(s):

Option A

None, alerts are accessible via the Cascade GUI only

Option B

SNMP traps only

Option C

SMTP email only

Option D

Pager only

Option E

One of SMTP email or SNMP trap but not both

Option F

SNMP traps and SMTP mail, each one optional, both allowed

Correct Answer F
Explanation

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