Indian Institute of Technology Kanpur (IIT-K) 2005 M.E Computer Science Gate CS - Question Paper

identical info as tuples. A new relation S’ is found by the subsequent relational algebra
operation:
S = ‘1hose/ ((Js.ro//_H.ro// (marks>75 and ro//>2000 and ro//<3000 (s)) X (H))
The difference ranging from the number of rows output by the SQL statement and the
number of tuples in S’ is:
(A) 6
(B) 4
(C) 2
(D)O

Table learner Table hobby
Roll Name Hoste
l
Mark
s
Roll Hobbyname
179
8
Manoj Rathod seven 95 179
8
Chess
215
4
Soumic Banerjee five 68 179
8
Music
236
9
Gumma Reddy seven 86 215
4
Music
258
1
Pradeep Pendse six 92 236
9
Swimming
264
3
Suhas Kulkarni five 78 258
1
Cricket
271
1
Nitin Kadam eight 72 264
3
Chess
287
2
Kiran Vora five 92 264
3
Hockey
292
6
Manoj Kunkalikar five 94 271
1
volleyball
295
9
Hemant
Karkhanis
7 88 287
2
Football
312
5
Rajesh Doshi five 82 292
6
Cricket
295
9
Photography
312
5
Music
312
5
Chess
69. In an inventory management system implemented at a trading corporation, there are
several tables designed to hold all the info. Amongst these, the subsequent 2 tables
hold info on which items are supplied by which suppliers, and which warehouse keeps
which items along with the stock-level of these items.
Supply = (supplierid, itemcode)
Inventory = (itemcode, warehouse, stocklevel)
For a specific info needed by the management, subsequent SQL query has
been written.
choose distinct STMP supplierid
From supply as STMP
Where not unique (Select ITMP.supplierid
From Inventory, Supply as ITMP
Where STMP.supplierid = ITMP.supplierid
And ITMP. itemcode = Inventory. itemcode
And Inventory.warehouse = ‘Nagpur’);
For the warehouse at Nagpur, this query will obtain all suppliers who
(A) do not supply any item
(B) supply exactly 1 item
(C) supply 1 or more items
(D) supply 2 or more items
70. In a schema with attributes A, B, C, D and E subsequent set of functional
dependencies are provided.
A-B
A-C
CD-E
B-D
E-A
Which of the subsequent functional dependencies is NOT implied by the above set?
(A) CD - AC
(B) BD - CD
(C) BC - CD
(D)AC - BC
71. A network with CSMA/CD protocol in the MAC layer is running at one Gbps over a one km cable
with no repeaters. The signal speed in the cable is 2x108m/sec. The minimum frame size for

Earning:   Approval pending.