question_answer

Which of the following statements) is/are true for UPDATE in SQL?

I. You can update only a single table using UPDATE command

II. You can update multiple tables using UPDATE command

III. In UPDATE command, you must list what columns to update with their new values

IV. To update multiple targeted records, you need to specify UPDATE command using the WHERE clause.

Select the correct option:

A) I, III and IV       

B) II, III and IV

C) III and IV             

D) I only