Title: Differentiate among TRUNCATE, DROP, and DELETE.
Course: Database Design and Management (Oracle) (10052) > Section: Modifying and Managing Tables

Differentiation of the commands should include the following:

- DROP
  - removes a table from the database
  - removes all of the tables’ rows, indexes, and privileges
  - cannot be rolled back

- TRUNCATE
  - removes all rows from a table
  - cannot be rolled back
  - is faster and does not use as much undo space as a DELETE
- DELETE
  - removes rows from a table
  - uses a WHERE clause to remove specified rows
  - removes all rows, unless a WHERE condition is specified
  - is made permanent or undoes changes by using COMMIT or ROLLBACK