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
How to use "startup" command to start default instance?
How to check your oracle database 10g xe installation?
Explain the use of parfile option in exp command.
How a database is related to tablespaces?
What is system global area (sga) in oracle?
How to experiment a data lock in oracle?
Explain a private synonyms?
What happens to the data files if a tablespace is dropped?
various types of hints and their usage
What is tns service name?
What are triggers in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is a nvl function?
Why we use bulk collect in oracle?
