GATE | Sudo GATE 2020 Mock I (27 December 2019) | Question 63

Consider the following relation algebra query:





Which of the following option is correct regarding above query ?
(A) Find the names of suppliers supplying some red part for less than 100 Quid and some green part for less than 100 Quid.
(B) Find the sids of suppliers supplying some red part for less than 100 Quid and some green part for less than 100 Quid, and return only sid’s of suppliers recorded in the table Supplier.
(C) Find the names of suppliers such that there is a supplier with that name supplying some red part for less than 100 Quid and a supplier with that name supplying some green part for less than 100 Quid.
(D) All of the these.


Answer: (A)

Explanation: Find the names of suppliers supplying some red part for less than 100 Quid and some green part for less than 100 Quid:




Find the sids of suppliers supplying some red part for less than 100 Quid and some green part for less than 100 Quid, and return only sid’s of suppliers recorded in the table Supplier:




Find the names of suppliers such that there is a supplier with that name supplying some red part for less than 100 Quid and a supplier with that name supplying some green part for less than 100 Quid:




So, option (A) is correct.

Quiz of this Question

My Personal Notes arrow_drop_up
Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.