Which SQL statement is used to insert a single row into a table?

• A. update
• B. insert into
• C. delete
• D. alter table

Answer: (B)

The statement used to add a new row of data into a table is INSERT INTO. This command specifies the target table, the columns to fill, and the values for those columns, creating a new row in the table. For example, inserting a single row might look like inserting values for an employee’s id, name, and role into the employees table.

Other options don’t fit because they perform different actions: updating changes data in existing rows, deleting removes rows, and altering the table changes the table’s structure or schema. INSERT INTO is specifically for creating new rows.