What is the result of the following SQL statement? UPDATE employee SET salary =
ID: 3661437 • Letter: W
Question
What is the result of the following SQL statement?
UPDATE employee
SET salary = 50000
WHERE salary < 50000;
The statement sets the salary for each employee to below 50,000
The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000
The statement increases salary to 50,000 for each employee whose salary is below 50,000
The statement sets the salary of each employee to 50,000
The statement sets the salary for each employee to below 50,000
The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000
The statement increases salary to 50,000 for each employee whose salary is below 50,000
The statement sets the salary of each employee to 50,000
Explanation / Answer
Ans:
The statement increases salary to 50,000 for each employee whose salary is below 50,000
UPDATE employee
SET salary = 50000
WHERE salary < 50000;
hence, the the statement increases salary to 50,000 for each employee whose salary is below 50,000
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.