Machine-translated by Google. Questions are authored in English.
Top

Discussion

The SQL DELETE statement is used to delete both the table structure and table data.

  • A.True
  • B.False

Answer: B

Correct answer: False

DELETE removes rows and leaves the table, its definition, its indexes and its constraints in place; an empty table remains. Removing the structure as well is DROP TABLE. The distinction is worth being certain of, since the two mistakes are not equally recoverable.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.