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

and then invokes p2. p2 in turn invokes p3, or p4, or p5.
(D) A new module Tc is described to control the transaction flow. This module Tc invokes p2. p2
invokes p1, and then invokes p3, or p4, or p5.
67. A company maintains records of sales made by its salespersons and pays them
commission based on every individual’s total sales made in a year. This data is maintained in a
table with subsequent schema:
salesinfo = (salespersonid, totalsales, commission)
In a certain year, due to better business results, the company decides to further reward its
salespersons by enhancing the commission paid to them as per the subsequent formula.
If commission < = 50000, enhance it by 2°h
If 50000 < commission < = 100000, enhance it by 4°h
If commission > 100000, enhance it by 6°h
The IT staff has written 3 various SQL scripts to compute enhancement for
every slab, every of these scripts is to run as a separate transaction as follows:
Ti Update salesinfo
Set commission = commission * 1.02
Where commission < = 50000;
T2 Update salesinfo
Set commission = commission * 1.04
Where commission > 50000 and commission is <= 100000;
T3 Update salesinfo
Set commission = commission * 1.06
Where commission > 100000;
Which of the subsequent choices of running these transactions will update the
commission of all salespersons correctly?
(A) Execute Ti followed by T2 followed by T3
(B) Execute T2, followed by T3; Ti running concurrently throughout
(C) Execute T3 followed by T2; Ti running concurrently throughout
(D) Execute T3 followed by T2 followed by Ti
68. A table ‘student’ with schema (roll, name, hostel, marks) and a different table ‘hobby’ with
schema (roll, hobbyname) contains records as shown beneath.
The subsequent SQL query is executed on the above tables:
choose hostel
from learner natural join hobby
where marks > = 75 and roll ranging from 2000 and 3000;
Relations S and H with the identical schema as those of these 2 tables respectively contain the
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

Earning:   Approval pending.