Select the right statement to insert values to the student table.
A. INSERT student VALUES (
B. INSERT VALUES (
C. INSERT INTO student VALUES (
D. INSERT VALUES INTO student (
Answer: Option C
Solution (By Examveda Team)
To insert values into a table using SQL, you should use the INSERT INTO statement, followed by the table name and the keyword VALUES. The correct syntax is:Option C: INSERT INTO student VALUES (
This option is the correct choice for inserting values into the "student" table.
Option A: INSERT student VALUES (
This option is incorrect because it lacks the "INTO" keyword.
Option B: INSERT VALUES (
This option is incorrect because it is missing the table name.
Option D: INSERT VALUES INTO student (
This option is also incorrect as it has an incorrect order of keywords.
So, the correct answer is Option C as it follows the proper syntax for inserting values into the "student" table in SQL.
Join The Discussion