Oracle Sql

 Table keyword-

alter, drop, truncate

delete- It will delete data of the table with where clause which can roll back.

Truncate-  It will delete data of the table which can not roll back. The TRUNCATE TABLE statement does not affect any of the table's indexes, triggers or dependencies.

Drop - Oracle DROP TABLE statement is used to remove or delete a table from the Oracle database.

If I used purge keyword then deleted table does not go recycle bin so it's not recoverable.

If there are referential integrity constraints on table_name and you do not specify the CASCADE CONSTRAINTS option, the DROP TABLE statement will return an error and Oracle will not drop the table.

DROP [schema_name].TABLE table_name  

[ CASCADE CONSTRAINTS ]  

[ PURGE ];