Which SQL command would you use to insert new data into a table?

• A. UPDATE
• B. INSERT
• C. REPLACE
• D. ADD

Answer: (B)

The command used to insert new data into a table in SQL is the INSERT statement. This command allows you to add one or more rows of data to an existing table, specifying the values that should populate each column.

Using the INSERT command is straightforward; you typically specify the table name, followed by the columns in which you want to insert data and the corresponding values. For instance, the SQL syntax looks like this:

INSERT INTO table_name (column1, column2) VALUES (value1, value2);

This will add a new row to "table_name" with the specified values for each column. The INSERT statement is integral to managing database records since it directly influences how new data is added and ensures that it adheres to the table's schema.

Other options do not serve the purpose of inserting data into a table. For instance, UPDATE is used to modify existing records, REPLACE might replace existing rows in some contexts but is not typically used as a straightforward insert command, and ADD is not a standard SQL command related to inserting data.