Multiple Choice
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') ;
Correct Answer:

Verified
Correct Answer:
Verified
Q3: Microsoft Access SQL commands are run within
Q12: Explain how to run an SQL query
Q70: Explain the essential format of the CREATE
Q84: Using standard SQL,unmatched rows will not appear
Q87: To open a new Microsoft Access Query
Q89: For a column to be defined as
Q90: The result for SELECT statements in SQL
Q91: Which of the following data types used
Q93: Explain two methods for defining a primary
Q105: What are SQL Built-in Functions?