Q
Which statement correctly updates a salary?
-
A
UPDATE emp SET salary = 5000 WHERE id = 5;
-
B
UPDATE emp VALUES salary = 5000 WHERE id = 5;
-
C
MODIFY emp SET salary = 5000 WHERE id = 5;
-
D
UPDATE emp TO salary = 5000 WHERE id = 5;
Correct Answer:
A. UPDATE emp SET salary = 5000 WHERE id = 5;
Explanation:
Syntax: UPDATE table SET column = value [WHERE ...].
