# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 2056844184

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Differentiate among TRUNCATE, DROP, and DELETE.

Definition

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