PrepAway - Latest Free Exam Questions & Answers

What is the result of the following query?

The EMPLOYEE table contains the following information:
EMPNO NAME WORKDEPT
——— —— —————
101 SAM A11
102 JOHN C12
103 JANE –
104 PAT Remote
105 ANNE –
106 BOB A11
The MANAGER table contains the following information:
MGRID NAME DEPTNO EMPCOUNT
——— ——– ———– —————
1 WU B01 –
2 JONES A11 –
3 CHEN – –
4 SMITH – –
5 THOMAS C12 –
After this statement is executed:
UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE
workdept=m.deptno)
What is the result of the following query?
SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid

PrepAway - Latest Free Exam Questions & Answers

A.
MGRID EMPCOUNT —– ——– 1 0 22 5 1

B.
MGRID EMPCOUNT —– ——– 1 0 22 3 0 4 0 5 1

C.
MGRID EMPCOUNT —– ——– 1 3 2 33 3 4 3 5 3

D.
MGRID EMPCOUNT —– ——– 1 0 22 3 2 4 2 5 1

One Comment on “What is the result of the following query?


Leave a Reply