Question

Which SQL keyword is used to change one or more rows in a table?

1) MODIFY
2) INSERT
3) SELECT
4) CHANGE
5) UPDATE

Answer 1

The SQL keyword used to change one or more rows in a table is 'UPDATE'. The UPDATE statement, coupled with SET and WHERE clauses, alters existing records in a database table.

Step-by-step explanation:

To change one or more rows in a table in SQL, the correct keyword to use is UPDATE. The UPDATE statement is used to modify existing records in a table. For example, if you want to change a customer's address in a customer table, you would use the UPDATE statement along with the SET clause to specify the new address and a WHERE clause to select the appropriate row.

Example:

UPDATE customers SET address = '123 New Address' WHERE customer_id = 1;

This command updates the address for the customer with an ID of 1. Remember, without the WHERE clause, the UPDATE statement will modify all rows in the table, so be cautious to include proper filtering conditions.