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

question 71

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

---

Definitions:

LEO

Stands for Low Earth Orbit, which is an orbit relatively close to Earth's surface where satellites can provide communication or remote sensing services.

MEO

Medium Earth Orbit, a designation for the orbit of satellites that reside in an orbit roughly between 2,000 and 35,786 kilometers above the Earth's surface.

Calibrated Instrument

A calibrated instrument is a device that has been tested and adjusted to ensure its accuracy and reliability in measurement, according to specified standards.

Federally Issued

Documents, currency, regulations or identification that are produced or sanctioned by the central government of a country.