In SQL, which command is used to add new rows to a table?

The correct answer is D. APPEND.

The APPEND command is used to add new rows to a table at the end of the table. The syntax for the APPEND command is as follows:

APPEND INTO table_name (column_list) VALUES (value_list);

The table_name is the name of the table to which you want to add rows. The column_list is a list of the columns that you want to add rows to. The value_list is a list of values that you want to insert into the columns.

For example, the following command would add a new row to the table customers with the values John Doe, 123 Main Street, and Anytown, CA 91234:

APPEND INTO customers (name, address, city, state, zip) VALUES ('John Doe', '123 Main Street', 'Anytown, CA 91234');

The ALTER TABLE command is used to modify the structure of a table. The syntax for the ALTER TABLE command is as follows:

ALTER TABLE table_name ADD column_name data_type;

The table_name is the name of the table that you want to modify. The column_name is the name of the new column that you want to add. The data_type is the data type of the new column.

For example, the following command would add a new column named phone to the table customers with the data type VARCHAR(255):

ALTER TABLE customers ADD phone VARCHAR(255);

The ADD ROW command is not a valid SQL command.

The INSERT command is used to insert new rows into a table. The syntax for the INSERT command is as follows:

INSERT INTO table_name (column_list) VALUES (value_list);

The table_name is the name of the table to which you want to insert rows. The column_list is a list of the columns that you want to insert rows into. The value_list is a list of values that you want to insert into the columns.

For example, the following command would insert a new row into the table customers with the values John Doe, 123 Main Street, and Anytown, CA 91234:

INSERT INTO customers (name, address, city, state, zip) VALUES ('John Doe', '123 Main Street', 'Anytown, CA 91234');