Database Management Question:

Download Job Interview Questions and Answers PDF

What is the difference between delete and truncate?

Database Management Interview Question
Database Management Interview Question

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?