SQL Insert
11.What is the main purpose of the UPDATE statement in SQL?
-
A. To remove data
-
B. To modify existing data
-
C. To create a new table
-
D. To merge tables
To modify existing data
To modify existing data
12.Which clause is required with UPDATE to avoid changing all rows?
-
A. SELECT
-
B. FROM
-
C. WHERE
-
D. ORDER BY
WHERE
WHERE