Midterm examinations & Quizzes PDF

Preview

Summary

Download Midterm examinations & Quizzes PDF

Description

Question 1 Answer saved Marked out of 1.00

Flag question

Question text Choose the letter of the correct answer based on the table EMPLOYEES as shown below. Table 1.0 EMPLOYEES

Based on the given SELECT statement below what would be the possible output? SELECT TRUNC(563.396,1)FROM DUAL; Select one: a. 563

b. 563.3 c. 500 d. 563.39 Question 2 Answer saved Marked out of 1.00

Flag question

Question text

SELECT COUNT(DISTINCT QTY) FROM STOCKS; Answer:

4

Question 3 Answer saved Marked out of 1.00

Flag question

Question text

SELECT COUNT(*) FROM STOCKS; Answer:

9

Question 4 Answer saved Marked out of 1.00

Flag question

Question text Which of the following query is correct which will display the same output as shown below?

Select one: a. SELECT COUNT *(DISTINCT MANAGER_ID) AS "NO. OF MANAGER_ID" FROM EMPLOYEES; b. SELECT COUNT(DISTINCT MANAGER_ID) AS "NO. OF MANAGER_ID" FROM EMPLOYEES; c. SELECT COUNT(MANAGER_ID) AS "NO. OF MANAGER_ID" FROM EMPLOYEES;

d. SELECT COUNT(DISTINCT MANAGER_ID) AS NO. OF MANAGER_ID FROM EMPLOYEES; Question 5 Answer saved Marked out of 1.00

Flag question

Question text Which of the following query is correct which will display the same output as shown below?

Select one: a. SELECT MIN(LASTNAME||FIRSTNAME) AS NAME, DEPARTMENT_ID FROM EMPLOYEES WHERE DEPARTMENT_ID IN(90,50) GROUP BY DEPARTMENT_ID HAVING(DEPARTMENT_ID)= 5000; b. SELECT MAX(FIRSTNAME), MANAGER_ID, COUNT(SALARY), AVG(SALARY) FROM EMPLOYEES WHERE SALARY BETWEEN 6000 AND 10000 GROUP BY MANAGER_ID HAVING (SALARY) >= 5000; c. SELECT MAX(FIRSTNAME), MANAGER_ID, COUNT(SALARY), AVG(SALARY) FROM EMPLOYEES WHERE SALARY BETWEEN 6000 AND 10000 HAVING MIN(SALARY) >= 5000 GROUP BY MANAGER_ID; d. SELECT MAX(FIRSTNAME), MANAGER_ID, COUNT(SALARY), AVG(SALARY) FROM EMPLOYEES GROUP BY MANAGER_ID WHERE SALARY BETWEEN 6000 AND 10000 HAVING MIN(SALARY) >= 5000;...