Which of the following SQL command is used to modify existing records in a…
2025
Which of the following SQL command is used to modify existing records in a relation based on specified conditions?
- A.
CHANGE
- B.
UPDATE
- C.
REPLACE
- D.
ALTER
Attempted by 122 students.
Show answer & explanation
Correct answer: B
The correct SQL command to modify existing records in a relation is UPDATE. This command allows users to change specific column values based on conditions specified in the WHERE clause.