Database Management Question:
Download Job Interview Questions and Answers PDF
What is the difference between delete and truncate?
Answer:
Truncate is a DDL command, which has autocommit hence
cant be rolled back where as delete is DML with user commit
& roll back option. Truncate is faster then delete since it
wont store any data to backup tablespace. before delting.
cant be rolled back where as delete is DML with user commit
& roll back option. Truncate is faster then delete since it
wont store any data to backup tablespace. before delting.
Download Database Management Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is the difference between oracle CPU and PSU? | What is ORACLE CLINICAL? |