examine the data in employees table given below lastname �departmentid salary allen..., Oracle SQL 9i, Databases

Test
- Model Test
Index

Question:Examine the data in the EMPLOYEES table given below:
LAST_NAME �DEPARTMENT_ID SALARY
ALLEN 10 3000
MILLER 20 1500
King 20 2200
Davis 30 5000
Which of the following Subqueries work?

A SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id); 
B SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id); 
C SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id); 
D SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id); 
E SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

/45

+ AnswerC D

+ Report

Descriptive on Oracle SQL 9i Ebook

Total Preview: 1196

Question:Examine the data in the EMPLOYEES table given below: LAST_NAME �DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries work?

A SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

B SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

C SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

D SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

E SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

C D