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 create a new oracle data file?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What are the most common interview questions on ETL Testing for experience?
What is Java Pool in Oracle?
How would you begin to troubleshoot an ORA-3113 error?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is a subquery?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is redo log?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is an Oracle index?
How to run queries on external tables?
Explain about achiever in sql?
Explain the use of consistent option in exp command.
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
