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

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. For example, `INSERT INTO customers (name, city) VALUES ('John Smith', 'London');`.
(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}.