What SQL command is used to insert new records into a table?

What SQL command is used to insert new records into a table?

• A. UPDATE
• B. DELETE
• C. INSERT
• D. SELECT

Answer: (C)

The SQL command used to insert new records into a table is the INSERT statement. This command allows you to add one or multiple new rows to a specified table by defining the values for each column of the new records. When you use the INSERT command, you specify the target table and provide the corresponding values for each column, either explicitly or by following the order of columns. For example, a basic usage of the INSERT command looks like this: ```sql INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3); ``` This statement effectively adds a new entry to the specified table with the provided values for each column listed. The other commands serve different purposes: the UPDATE command modifies existing records, DELETE removes records from a table, and SELECT retrieves data without altering the database. Thus, the INSERT command is specifically designed for adding new entries, making it the correct choice for this query.

The SQL command used to insert new records into a table is the INSERT statement. This command allows you to add one or multiple new rows to a specified table by defining the values for each column of the new records.

When you use the INSERT command, you specify the target table and provide the corresponding values for each column, either explicitly or by following the order of columns. For example, a basic usage of the INSERT command looks like this:

INSERT INTO table_name (column1, column2, column3)

VALUES (value1, value2, value3);

This statement effectively adds a new entry to the specified table with the provided values for each column listed.

The other commands serve different purposes: the UPDATE command modifies existing records, DELETE removes records from a table, and SELECT retrieves data without altering the database. Thus, the INSERT command is specifically designed for adding new entries, making it the correct choice for this query.