READ Free Dumps For Oracle- 1z0-007

Question ID 7879	Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 HR_MGR 5000 106 Bryan 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?
Option A	SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;
Option B	SELECT e.employee_id "Emp_id", e.emp_name "Employee",
Option C	salary,
Option D	employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;
Option E	SELECT e.employee_id "Emp_id", e.emp_name "Employee",
Option F	salary,
Correct Answer	C

Explanation Explanation/Reference: Explanation: This statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000 Incorrect Answers A: This statement does not check does employee have a manager or not, so it will not provide correct result. B: Usage of "e.mgr_id = m.mgr_id" condition is wrong to achieve required result. D: This statement uses "m.mgr_id" to show manager's manager, not employ's manager. E: Usage of "WHERE e.employee_id = m.employee_id" condition is wrong to achieve required result. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 118-122 Chapter 3: Advanced Data Selection in Oracle

Question ID 7880	In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?
Option A	Immediately after the SELECT clause
Option B	Before the WHERE clause
Option C	Before the FROM clause
Option D	After the ORDER BY clause
Option E	After the WHERE clause
Correct Answer	E

Explanation Explanation/Reference: Explanation: The GROUP BY clause can be place only after the WHERE clause, or after FROM clause if there is no the WHERE clause in the statement. Incorrect Answers A: It is not possible to place the GROUP BY clause immediately after the SELECT clause. B: It is not possible to place the GROUP BY clause before the WHERE clause, it can be done only after it. C: It is not possible to place the GROUP BY clause before the FROM clause. D: It is not possible to place the GROUP BY clause after the ORDER BY clause. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 56-67 Chapter 2: Limiting, Sorting, and Manipulating Return Data

Previous-Page 1 2. . . 69 70 71 72 73 74 75. . . 160 161 Next-Page

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