Question

Which command is used to create a new row in SQL ?

• A. Insert into
• B. Alter table
• C. Update
• D. All of these

Hint:

To add new things: `CREATE` for new tables, `INSERT INTO` for new rows. To change existing things: `ALTER` for tables, `UPDATE` for rows.

Answer 1

The Correct Option is A

This question is a duplicate of question 28. Step 1: Understand the task. The goal is to add a completely new row of data to an existing table.
Step 2: Analyze the SQL commands.

(A) \text{INSERT INTO}: This is the standard SQL command used to add one or more new rows to a table.
(B) \text{ALTER TABLE}: This is a DDL command used to change the structure of the table itself (e.g., add or remove a column), not the data rows.
(C) \text{UPDATE}: This command modifies data in existing rows, but does not create new ones.
The correct command to create a new row is \text{INSERT INTO}.