Explain the difference between DELETE , TRUNCATE and DROP commands?

Answer

Once delete operation is performed, Commit and Rollback can be performed to retrieve data.

Once the truncate statement is executed, Commit and Rollback statement cannot be performed. Where condition can be used along with delete statement but it can't be used with truncate statement.

Drop command is used to drop the table or keys like primary,foreign from a table.