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?

UPDATE STUDENT SET Advisor $=$ 'Smith',

MODIFY STUDENT SET Advisor $=$ 'Smith',

UPDATE Advisor $=$ 'Smith',

SET STUDENT Advisor $=$ 'Smith',

Question not answered