Given the Table STUDENT(StudentID,Name,Advisor),which of the Following SQL Statements Would

Multiple Choice

Given the table STUDENT(StudentID,Name,Advisor) ,which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

A) UPDATE STUDENT SET Advisor = 'Smith';
B) MODIFY STUDENT SET Advisor = 'Smith';
C) MODIFY Advisor SET STUDENT = 'Smith';
D) UPDATE Advisor = 'Smith';
E) SET STUDENT Advisor = 'Smith';