Question

What is the syntax to load data into the database? (Consider D as the database and a, b, c as data)

(a) enter into D (a, b, c);

(b) insert into D values (a, b, c);

(c) insert into D (a, b, c);

(d) insert (a, b, c) values into D;

I had been asked this question in an international level competition.

This intriguing question originated from SQL Data definition topic in chapter Introduction to Relational Model and Sql of RDBMS

Answer 1

Correct answer is (b) insert into D values (a, b, c);

To explain I would say: To load data into a database we use the insert into command. The syntax is

          insert into D values (a, b, c) where a, b, c are the appropriate values