Question: 5. An SQL data type of ________________ would indicate a variable-length character string with maximum length 75. 6. Given the table STUDENT(StudentID, Name, Advisor) ,

5. An SQL data type of ________________ would indicate a variable-length character string with maximum length 75.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!