Which of the following SQL commands is used to change the attribute values of…
2023
Which of the following SQL commands is used to change the attribute values of one or more rows in a table?
- A.
Update
- B.
Insert
- C.
Alter
- D.
More than one of the above
- E.
None of the above
Attempted by 1315 students.
Show answer & explanation
Correct answer: A
To change the attribute values of one or more rows in a table, the SQL command used is UPDATE. Step 1: The UPDATE command modifies existing records in a table. Step 2: It allows changing values of one or more columns for specific rows based on a condition. Step 3: Other commands like INSERT add new rows, and ALTER changes table structure, not row values. Therefore, UPDATE is the correct command for changing attribute values in existing rows.