Multiple choice technology architecture

There is a table called Employee having columns are empno, ename , job , deptno,grade and salary. Which of the following is a correct query to change all emp salary with salary<10000 to 1.5 times and grade to ‘Promo’

  1. Update Employee set salary = salary * 1.5 and grade=’Promo’ where salary < 10000;

  2. Update Employee set salary = salary * 1.5, grade=’Promo’ where salary < 10000;

  3. Update table Employee set salary = salary * 1.5, grade=’Promo’ where salary < 10000;

  4. Update table Employee set salary = salary * 1.5 and grade=’Promo’ where salary < 10000;
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL UPDATE statements, multiple column assignments must be separated by commas, not the AND keyword. The correct syntax is 'UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition'. Option A incorrectly uses 'and' instead of a comma. Options C and D incorrectly include 'table' keyword after UPDATE.

Keep practicing — related questions