Question

What type of clause must you always use with DELETE or UPDATE to avoid inadvertently changing data elsewhere in the database?

A. FROM
B. ORDER
C. SET
D. WHERE

Answer 1

D. WHERE

Step-by-step explanation:

When using the DELETE or UPDATE statements in SQL, it's important to use a WHERE clause to avoid inadvertently changing data elsewhere in the database. The WHERE clause is used to specify the condition for the deletion or update of the data. This condition defines which rows or columns of data will be affected by the DELETE or UPDATE statement.

Without the WHERE clause, the DELETE or UPDATE statement will change all rows in the table, which can cause serious data loss and errors in the database.