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- 1z1-051





Question ID 4970

Option A

A.    listing the employees who earn the same amount of commission as employee 3
 

Option B

B.    finding the total commission earned by the employees in department 10
 

Option C

C.    finding the number of employees who earn a commission that is higher than the average commission of the company
 

Option D

D.    listing the departments whose average commission is more that 600
 

Option E

E.    listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID
 

Option F

F.    listing the employees whose annual commission is more than 6000
 

Correct Answer A,C
Explanation


Question ID 4971

Evaluate this SQL statement:
SELECT e.emp_name, d.dept_name
FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40)
ORDER BY dept_name;
 
The statement fails when executed. Which change fixes the error?
 

Option A

A.    remove the ORDER BY clause
 

Option B

B.    remove the table alias prefix from the WHERE clause
 

Option C

C.    remove the table alias from the SELECT clause
 

Option D

D.    prefix the column in the USING clause with the table alias
 

Option E

E.    prefix the column in the ORDER BY clause with the table alias
 

Option F

F.    replace the condition”d.department_id NOT IN (10,40)”in the WHERE clause with”d.department_id <> 10 AND d.department_id <> 40”
 

Correct Answer C,E
Explanation

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