A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. Consider the following relational schema:

Suppliers(sid:integer, sname:string, city:string, street:string)
Parts(pid:integer, pname:string, color:string)
Catalog(sid:integer, pid:integer, cost:real)

Consider the following relational query on the above database:

SELECT S.sname
FROM Suppliers S
WHERE S.sid NOT IN (SELECT C.sid
FROM Catalog C
WHERE C.pid NOT IN (SELECT P.pid
FROM Parts P
WHERE P.color<> 'blue'))

Assume that relations corresponding to the above schema are not empty. Which one of the following is the correct interpretation of the above query?
a. Find the names of all suppliers who have supplied a non-blue part.
b. Find the names of all suppliers who have not supplied a non-blue part.
c. Find the names of all suppliers who have supplied only blue parts.
d. Find the names of all suppliers who have not supplied only blue parts.
Answer:Find the names of all suppliers who have supplied a non-blue part.

Similar Questions:



View All Questions on: SQL


Start The Conversation: