Consider the following SQL query: PROJ (Pnum, Dnum) DEPT (Dnumber, Mgr_SSn)…
PYQ KVS TGT/PGT 2018
Consider the following SQL query:
PROJ (Pnum, Dnum)
DEPT (Dnumber, Mgr_SSn)
EMP (fname, lname, SSn)
WORKS_ON (Pno, ESSn)
(SELECT DISTINCT Pnum FROM PROJ, DEPT, EMP WHERE Dnum = Dnumber AND Mgr_SSn = SSn AND Lname = 'XXXX')
UNION
(SELECT DISTINCT Pnum FROM PROJ, WORKS_ON, EMP WHERE Pnum = Pno AND ESSn = SSn AND Lname = 'XXXX')
What does the query return?
- A.
All project numbers for projects that involve an employee with last name 'XXXX', either as worker or as manager
- B.
All project numbers for projects that involve an employee with last name 'XXXX' as manager
- C.
Records of all employees with last name 'XXXX' working in a project as manager
- D.
All project numbers for projects in department Dnumber and where 'XXXX' is involved either as worker or as manager
Attempted by 252 students.
Sign up free to check your answer
Sign up freeLoading lesson…

