Database Management Question:
Download Questions 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.

Download Database Management Interview Questions And Answers PDF

Previous QuestionNext Question
What is the difference between oracle CPU and PSU?What is ORACLE CLINICAL?