SQL INSERT Command MCQ INSERT Statement Practice Questions

Direction: Choose the correct option

Which SQL statement is used to add new rows to a table?

A. INSERT INTO

B. CREATE ROW

C. ADD ROW

D. APPEND

Direction: Choose the correct option

INSERT INTO students (id, name) VALUES (1, 'John');

What happens if you don't specify all columns?

A. Error if columns are NOT NULL

B. NULL values inserted

C. Both B and C

D. Default values used

Direction: Choose the correct option

How do you insert multiple rows in a single INSERT statement?

A. Use multiple VALUES clauses

B. Use INSERT ALL

C. Use multiple INSERT statements

D. Use INSERT MULTIPLE

Direction: Choose the correct option

INSERT INTO customers VALUES (1, 'John', 'john@email.com');

What assumption does this query make?

A. Values must match column order

B. Column names don't matter

C. All of the above

D. Table has exactly 3 columns

Direction: Choose the correct option

How do you insert data from one table into another?

A. COPY FROM ... TO

B. INSERT INTO ... SELECT

C. INSERT AS SELECT

D. INSERT INTO ... FROM

Quipoin Menu