While (select sum(salary) from projects) 50000 begin Which of the following stat

Question

While (select sum(salary) from projects) 50000 begin Which of the following statements is true in regards to the statement? If a salary is increased to more than 50000, that salary is no longer increased, but all others will be until the sum of all salaries is greater than or equal to 100000. If a salary is increased to more than 50000, ne further salaries will be increased. Salaries will continue to increase until the highest salary is greater than or equal to 100000. Salaries will continue to increase until the sun of all salaries is greater than or equal to 50000.

Explanation / Answer

Ans) B. If a salary is increased to more than 50000 no further salaries will be increased.

Reason:

this while loop every time will calculate the sum of all values in the column salary .if the sum is less than 100000 then the salaries will be incremented , this procedure will continue until if any of the salary is greater than 50000.

____________Thank You

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.