Q67

A company maintains records of sales made by its salespersons and pays them commission based on each individual's total sales made in a year. This data is maintained in a table with following 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 following formula: If commission $\leq 50000,$ enhance it by $2\%$ If $50000 <$ commission $\leq 100000,$ enhance it by $4\%$ If commission $> 100000,$ enhance it by $6\%$ The IT staff has written three different SQL scripts to calculate enhancement for each slab, each of these scripts is to run as a separate transaction as follows: T1Update salesinfo Set commission = commission * 1.02 Where commission < = 50000; T2Update salesinfo Set commission = commission * 1.04 Where commission > 50000 and commission is < = 100000; T3Update salesinfo Set commission = commission * 1.06 Where commission > 100000; Which of the following options of running these transactions will update the commission of all salespersons correctly