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

Question

Quizplus · Accepted Answer

To add new student data to the table, we need to use the INSERT INTO statement followed by the table name and the values we want to insert. The correct syntax for this statement is:
INSERT INTO STUDENT (StudentID, Name, Advisor) VALUES (123, 'Jones', 'Smith');
This statement specifies the columns we want to insert data into (StudentID, Name, and Advisor) and the values we want to insert for each column. Choice A is not a valid syntax for inserting data. Choice C is also incorrect as it uses an invalid column name. Choice D and E are not valid SQL statements.

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