Indian Institute of Technology Mumbai (IIT-M) 2005 M.E Information Technology GATE IT - Question Paper

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
this network should be
(A) 10000 bits
(B) 10000 bytes
(C) 5000 bits
(D)5000 bytes
72. A channel has a bit rate of four kbps and one-way propagation delay of 20 ms. The channel
uses stop and wait protocol. The transmission time of the acknowledgement frame is

Earning:   Approval pending.