Answer Posted / ashu singh
Drop deletes the table along with its structure from the database.
Delete command deletes the records from the table and it also deletes the table space allocated in the database.
Truncate is similar to Delete but it does not delete the table space from the database.
Drop and Truncate are the DDL command hence can't be rolled back whereas Delete is a DML command and can be rolled back.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
How to declare a local variable?
In which language oracle has been developed?
What would you do with an in-doubt distributed transaction?
Explain self joins in oracle?
What is a table index?
What to do if the binary spfile is wrong for the default instance?
How to delete a column in an existing table in oracle?
What are ddl statements in oracle?
what are the advantages of running a database in archive log mode?
Can we create trigger on materialized view in oracle?
What is program global area (pga) in oracle?
Difference between pre-select and pre-query
What is key preserved table?
Please explain compound trigger in oracle?
interview questions with answer for cts
