Which of the following statements can be used to increase the marks of all students in science
subject by 10%?
A.
UPDATE student WHERE subject = ‘science’ SET marks = marks * 1.1
B.
UPDATE student SET marks = (marks * 1.1)
C.
UPDATE student SET marks = marks * 1.1 WHERE subject = ‘science’
D.
UPDATE marks = marks * 1.1 ON TABLE student WHERE subject = ‘science’
Explanation: