Which of the following SQL commands is used to change the attribute values of one or more rows in a table?

Correct option is A

The UPDATE SQL command is used to change the attribute values of one or more rows in a table. This command allows you to modify existing data in a table based on specific conditions, ensuring that only the required rows are updated. You can also use the WHERE clause to specify which rows should be updated.
Important Key Points:
1. UPDATE Command: The UPDATE command is specifically designed to modify the values of existing rows in a table. It is often used when the values of certain attributes need to be changed without affecting the structure of the table.
2. WHERE Clause: The WHERE clause is typically used in conjunction with the UPDATE command to specify which rows should be updated. If no WHERE clause is used, all rows in the table will be updated.
3. Multiple Columns: You can update one or more columns in a row using the UPDATE command. Multiple columns can be updated at once, with each column receiving a new value.
Knowledge Booster:
· Insert: The INSERT command is used to add new rows of data into a table, not to modify existing rows.
· Alter: The ALTER command is used to modify the structure of a table (such as adding or dropping columns), not to change the values of the rows.