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: