Question Description
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 < = 50000, enhance it by 2% If 50000 < commission < = 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:Q.Which of the following options of running these transactions will update the commission of all salespersons correctlya)Execute T1 followed by T2 followed by T3b)Execute T2, followed by T3; T1 running concurrently throughoutc)Execute T3 followed by T2; T1 running concurrently throughoutd)Execute T3 followed by T2 followed by T1Correct answer is option 'D'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about 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 < = 50000, enhance it by 2% If 50000 < commission < = 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:Q.Which of the following options of running these transactions will update the commission of all salespersons correctlya)Execute T1 followed by T2 followed by T3b)Execute T2, followed by T3; T1 running concurrently throughoutc)Execute T3 followed by T2; T1 running concurrently throughoutd)Execute T3 followed by T2 followed by T1Correct answer is option 'D'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for 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 < = 50000, enhance it by 2% If 50000 < commission < = 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:Q.Which of the following options of running these transactions will update the commission of all salespersons correctlya)Execute T1 followed by T2 followed by T3b)Execute T2, followed by T3; T1 running concurrently throughoutc)Execute T3 followed by T2; T1 running concurrently throughoutd)Execute T3 followed by T2 followed by T1Correct answer is option 'D'. Can you explain this answer?.

Solutions for 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 < = 50000, enhance it by 2% If 50000 < commission < = 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:Q.Which of the following options of running these transactions will update the commission of all salespersons correctlya)Execute T1 followed by T2 followed by T3b)Execute T2, followed by T3; T1 running concurrently throughoutc)Execute T3 followed by T2; T1 running concurrently throughoutd)Execute T3 followed by T2 followed by T1Correct answer is option 'D'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.

Here you can find the meaning of 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 < = 50000, enhance it by 2% If 50000 < commission < = 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:Q.Which of the following options of running these transactions will update the commission of all salespersons correctlya)Execute T1 followed by T2 followed by T3b)Execute T2, followed by T3; T1 running concurrently throughoutc)Execute T3 followed by T2; T1 running concurrently throughoutd)Execute T3 followed by T2 followed by T1Correct answer is option 'D'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of 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 < = 50000, enhance it by 2% If 50000 < commission < = 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:Q.Which of the following options of running these transactions will update the commission of all salespersons correctlya)Execute T1 followed by T2 followed by T3b)Execute T2, followed by T3; T1 running concurrently throughoutc)Execute T3 followed by T2; T1 running concurrently throughoutd)Execute T3 followed by T2 followed by T1Correct answer is option 'D'. Can you explain this answer?, a detailed solution for 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 < = 50000, enhance it by 2% If 50000 < commission < = 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:Q.Which of the following options of running these transactions will update the commission of all salespersons correctlya)Execute T1 followed by T2 followed by T3b)Execute T2, followed by T3; T1 running concurrently throughoutc)Execute T3 followed by T2; T1 running concurrently throughoutd)Execute T3 followed by T2 followed by T1Correct answer is option 'D'. Can you explain this answer? has been provided alongside types of 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 < = 50000, enhance it by 2% If 50000 < commission < = 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:Q.Which of the following options of running these transactions will update the commission of all salespersons correctlya)Execute T1 followed by T2 followed by T3b)Execute T2, followed by T3; T1 running concurrently throughoutc)Execute T3 followed by T2; T1 running concurrently throughoutd)Execute T3 followed by T2 followed by T1Correct answer is option 'D'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice 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 < = 50000, enhance it by 2% If 50000 < commission < = 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:Q.Which of the following options of running these transactions will update the commission of all salespersons correctlya)Execute T1 followed by T2 followed by T3b)Execute T2, followed by T3; T1 running concurrently throughoutc)Execute T3 followed by T2; T1 running concurrently throughoutd)Execute T3 followed by T2 followed by T1Correct answer is option 'D'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.