Vidyalelo
SQL · Q16

SQL

Programming · SQL · question 16

Q16

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

A.
SAVE
B.
UPDATE
Answer
C.
SAVE AS
D.
MODIFY

Answer: Option B

Solution

Answer: Option B
Solution:
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.