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

  1. UPDATE

  2. MODIFY

  3. SAVE

  4. SAVE AS


Correct Option: A

AI Explanation

To answer this question, you need to understand the basic SQL syntax and operations.

The correct answer is A) UPDATE.

Explanation for each option:

A) UPDATE - This option is correct. The UPDATE statement is used to modify or update existing data in a database table.

B) MODIFY - This option is incorrect. The MODIFY statement is not a valid SQL statement for updating data. It is typically used in conjunction with the ALTER TABLE statement to modify the structure or definition of a table.

C) SAVE - This option is incorrect. The SAVE statement is not a valid SQL statement for updating data. SQL does not have a specific statement for saving data in a database.

D) SAVE AS - This option is incorrect. The SAVE AS statement is not a valid SQL statement for updating data. SQL does not have a specific statement for saving data with a new name or as a copy.

In conclusion, the correct answer is A) UPDATE. This statement is used to modify or update existing data in a database table.

Find more quizzes: