Planning to take coaching on Unacademy
http://bit.ly/gate_unacademy
or
https://unacademy.com/
here is a code for 10% off PLUS1BPK1
Telegram Notification Group link:-
https://t.me/joinchat/X5egW_cvdt9kMGY1
Telegram discussion Group link:-
https://t.me/joinchat/VCyGUmVq8RNkMzhl
Downloads resources from here
https://education4fun.com/gate-cse/
MCQ (Single Correct Answer)
GATE CSE 2014 Set 3
Consider the following relational schema:
employee (empId, empName, empDept )
customer (custId, custName, salesRepId, rating)
SalesRepId is a foreign key referring to empId of the employee relation. Assume that each employee makes a sale to at least one customer. What does the following query return?
A) Names of all the employees with at least one of their customers having a 'GOOD' rating.
B) Names of all the employees with at most one of their customers having a 'GOOD' rating.
C) Names of all the employees with none of their customers having a 'GOOD' rating.
D) Names of all the employees with all their customers having a 'GOOD' rating.
