The payload example that attempts to modify an existing row demonstrates which SQL operation?

The payload example that attempts to modify an existing row demonstrates which SQL operation?

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

Answer: (C)

Updating data in place is what this payload represents. In SQL, the UPDATE statement is used to change the values of existing rows that match a given condition (usually specified with a WHERE clause). When a payload tries to modify an existing row, it’s exercising the UPDATE operation, altering the data that’s already stored rather than adding new data or changing the table itself. To contrast the other operations: a SELECT simply reads data and returns it without changing anything; an INSERT adds a new row to the table; and ALTER changes the table’s structure (such as adding or removing columns). So the behavior of modifying an existing row clearly points to an UPDATE operation.

Updating data in place is what this payload represents. In SQL, the UPDATE statement is used to change the values of existing rows that match a given condition (usually specified with a WHERE clause). When a payload tries to modify an existing row, it’s exercising the UPDATE operation, altering the data that’s already stored rather than adding new data or changing the table itself.

To contrast the other operations: a SELECT simply reads data and returns it without changing anything; an INSERT adds a new row to the table; and ALTER changes the table’s structure (such as adding or removing columns). So the behavior of modifying an existing row clearly points to an UPDATE operation.