GATE 2022: Database Management system Quiz-3
Attempt now to get your rank among 349 students!
Suppliers (sid: integer, sname: string, address: string)
Parts (pid: integer, pname: string, color: string)
Catalog (sid: integer, pid: integer, cost: real)
The key ﬁelds are underlined, and the domain of each ﬁeld is listed after the ﬁeld name. Therefore sid is the key for Suppliers, pid is the key for Parts, and sid and pid together form the key for Catalog. The Catalog relation lists the prices charged for parts by Suppliers.
Which of the following query generate the list of pair of Sids such that the supplier with first sid charges more for some part than supplier with the second sid?
i) The function of the unique constraint to ensures that no two values under an attribute are identical
ii) The functions of on delete cascade is used to delete a tuple in a table
iii) The function of the not null constraint to prevents illegal data from being entered into the database
Number of elements in the output of the following query?
A name,Age(R Place=’Mumbai’(Employee (Natural Join) City))
- 349 attempts
- 1 upvote
- 1 comment