Which SQL command is used to add new rows to a database table?

2024

Which SQL command is used to add new rows to a database table?

  1. A.

    ADD

  2. B.

    CREATE

  3. C.

    INSERT

  4. D.

    More than one of the above

  5. E.

    None of the above

Attempted by 1550 students.

Show answer & explanation

Correct answer: C

The correct SQL command to add new rows to a database table is INSERT. This command is used to insert data into a table by specifying the column values. For example: INSERT INTO table_name (column1, column2) VALUES (value1, value2); The ADD command is used to add new columns to an existing table, not rows. The CREATE command is used to create a new table, not to insert data. The option 'More than one of the above' is incorrect because only INSERT is used for adding rows. The option 'None of the above' is incorrect because INSERT does add rows.

Explore the full course: Up Lt Grade Assistant Teacher 2025