Which SQL statement is used to update data in a database?

Solution (By Examveda Team)

The SQL statement used to update data in a database is UPDATE. Here's a brief explanation of each option:

Option A: SAVE
There is no standard SQL command called SAVE for updating data in a database.

Option B: UPDATE
The UPDATE command is used to modify existing records in a database table. It allows you to change the values of specific columns in one or more rows based on specified conditions.

Option C: SAVE AS
SAVE AS is not a standard SQL command used for updating data. It's not typically used in SQL for data modification.

Option D: MODIFY
MODIFY is not a standard SQL command for updating data. It may be used in some specific database systems, but it's not a commonly recognized SQL command for data updates.

So, the correct SQL statement to update data in a database is Option B: UPDATE.