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';

Question

Quizplus · Accepted Answer

The UPDATE statement in SQL is used to modify the records in a table. In this case, we want to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table. The correct syntax for the UPDATE statement is "UPDATE table_name SET column_name = new_value". Therefore, the correct SQL statement to use in this scenario would be "UPDATE STUDENT SET Advisor = 'Smith'". Options B, C, D, and E are all incorrect syntax for updating records in a SQL table.

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