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
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How can Oracle users be audited?
what is the use of system.effective.date variable in oracle?
What happens to the current transaction if the session is ended?
How different is ms access and oracle?
What are the limitations of check constraint?
How to assign values to variables?
How to use "in out" parameter properly?
how can we store any pdf file in oracle
Can we connect to ORACLE db using Windows Authentication?
How to create a new tablespace in oracle?
How to start a specific oracle instance?
How to specify default values in insert statement using oracle?
List out the types of joins.
What is oracle instant client?