Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are the types of trigger in oracle?
How to drop an existing table in oracle?
Explain the features of oracle?
Explain oracle instance.
What is a nvl function? How can it be used?
How to create lov dynamically at runtime & attach to text field?
What is a data dictionary and how can it be created?
What is index in Oracle?
What is integrity and what is constraint??Explain with example
What language does oracle use?
What is the max number of columns in an oracle table?
What are the extensions used by oracle reports?
Is a rollback possible to any savepoint?
How do you store pictures in a database?
How to use regular expression in pattern match conditions in oracle?
