The payload example that inserts a new row demonstrates which SQL operation?

The payload example that inserts a new row demonstrates which SQL operation?

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

Answer: (C)

In SQL, adding a brand-new record to a table is done with the INSERT statement. A payload that inserts a new row is using INSERT to supply values for the table’s columns, creating a new record rather than changing or removing existing data. For example, an INSERT fills in values for fields like username and email to make a new row in the users table. This is different from UPDATE, which changes existing rows; DELETE, which removes rows; and DROP, which deletes an entire table or object. So the payload that adds a new row is demonstrating the INSERT operation.

In SQL, adding a brand-new record to a table is done with the INSERT statement. A payload that inserts a new row is using INSERT to supply values for the table’s columns, creating a new record rather than changing or removing existing data. For example, an INSERT fills in values for fields like username and email to make a new row in the users table. This is different from UPDATE, which changes existing rows; DELETE, which removes rows; and DROP, which deletes an entire table or object. So the payload that adds a new row is demonstrating the INSERT operation.