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 is a data lock in oracle?
What is the difference between 10g OEM and 11g OEM?
How to define and use table alias names in oracle?
What is format trigger?
How can we find out the current date and time in oracle?
Explain what are the type of synonyms?
What is meant by joins? List out the types of joins.
Can a parameter be passed to a cursor?
Explain index?
Explain the features of oracle?
How do I know if oracle client is installed on windows?
What happens if you lost a data file?
Can we insert data in view oracle?
How to write a query with an inner join in oracle?
What are the roles of dba?
