Diff b/w Delete, Truncate, Drop

DELETE

1. Deletes some or all rows of a table
2. It is DML
3. Commited
4. Uncommitted deletes can be rolled back
5. Yes, DELETE triggers fired

TRUNCATE

1. Deletes all rows of a table
2. It is DDL
3. Not Commited
4. Cannot be rolled back – once truncated, gone forever
5. No triggers fired

DROP

1. Removes all rows and also the table definition, including indexes, triggers, grants, storage parameters
2. It is DDL
3. Not Commited
4. A dropped table can be reinstated from the recycle bin 
5. No triggers fired