Q16
Which SQL statement is used to update data in a database?
A.
SAVE
B.
UPDATE
AnswerC.
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:
SAVEThere is no standard SQL command called
SAVE for updating data in a database.Option B:
UPDATEThe
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 ASSAVE AS is not a standard SQL command used for updating data. It's not typically used in SQL for data modification.Option D:
MODIFYMODIFY 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.