Examveda

What is the table name in the following SQL code?
INSERT INTO student VALUES('Kyle','M',NULL);

A. student

B. VALUES

C. Kyle

D. M

Answer: Option A

Solution (By Examveda Team)

This question is about understanding the basic structure of an SQL query.
SQL stands for Structured Query Language, a language used to communicate with databases. One common type of SQL query is the INSERT statement, used to add new data into a table.
The INSERT statement has the following basic structure:
INSERT INTO _table_name_ VALUES (_data_values_);
In this query:
INSERT INTO student VALUES('Kyle','M',NULL);
The word student is the table name where we want to insert the data.
Therefore, the correct answer is Option A: student.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous