Which SQL clause is used to restrict the records affected by a DELETE statement?

Options

  • A. ORDER BY
  • B. GROUP BY
  • C. WHERE
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. WHERE

Detailed Explanation

  • WHERE clause: Specifies the condition for selecting rows to be deleted.
  • Without WHERE, DELETE removes all rows from the target table.
  • Always verify the condition before executing a DELETE statement.
← Previous Next →

Attempt Quiz Now:

TRE 4.0 DBMS Quiz Practice Set 2

Feature Posts