Blog

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table?
A) INSERT DATA STUDENT SET StudentID=123, Name=’Jones’, Advisor=’Smith’;
B) INSERT INTO STUDENT VALUES (123, ‘Jones’, ‘Smith’);
C) INSERT INTO STUDENT (New Student Data) VALUES (123, ‘Jones’, ‘Smith’);
D) INPUT DATA STUDENT SET StudentID=123, Name=’ Jones’, Advisor=’Smith’;
E) INPUT INTO STUDENT (123, ‘Jones’, ‘Smith’);