Multiple choice

What will be the output of the following query? select count(*) from employees e1, e2, department d where e1.lname='abc , e1.fname='xyz', e1.empid=d.mgrempid and d.dptno=e2.dptno. Tables: Employee(empid,fname,lname,add,dob,position,deptno) Dpartment(deptno,deptname,mgrempid) Project(projno,projname,deptno) Workson(empid,projno,hoursworked)

  1. It finds out how many employees are managed by 'xyz abc'.

  2. It finds the list of employees that are managed by 'xyz abc'.

  3. It counts the number of managers bearing the name 'xyz abc'

  4. It finds out the managers bearing the name 'xyz abc'

  5. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Output : count(*)Condition : Manager name 'xyz abc'Table : Employee, Department This query finds out how many employees are managed by 'xyz abc'.

Keep practicing — related questions