Vidyalelo
SQL · Q72

SQL

Programming · SQL · question 72

Q72

Select the right statement to insert values to the student table.

A.
INSERT student VALUES (
B.
INSERT VALUES (
C.
INSERT INTO student VALUES (
Answer
D.
INSERT VALUES INTO student (

Answer: Option C

Solution

Answer: Option C
Solution:
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.