Which of the following statements about the DELETE command is incorrect?
A) The DELETE command applies to an entire row and cannot be applied to specific columns within a row.
B) The proper command syntax for the DELETE command is DELETE FROM tablename;
C) If you omit the optional WHERE clause,then all the rows in the table will be deleted.
D) If you omit the mandatory WHERE clause,an error message will be issued.

Question

​Which of the following statements about the DELETE command is incorrect?
A) ​The DELETE command applies to an entire row and cannot be applied to specific columns within a row.
B) ​The proper command syntax for the DELETE command is DELETE FROM tablename;
C) ​If you omit the optional WHERE clause,then all the rows in the table will be deleted.
D) ​If you omit the mandatory WHERE clause,an error message will be issued.

Quizplus · Accepted Answer

The statement "If you omit the mandatory WHERE clause,an error message will be issued" is incorrect. If you omit the WHERE clause, then all the rows in the table will be deleted without any error message.

​Which of the Following Statements About the DELETE Command Is

Which of the Following Statements About the DELETE Command Is