1.

Explain the difference between delete and truncate?

Answer»
S.noTRUNCATEDELETE
1.Rollback of the DATA is not possibleRollback of the data is possible
2.All the records are deletedCan delete a specific record USING the WHERE condition.
3.Uses LESS transaction spaceUse more transaction space


Discussion

No Comment Found

Related InterviewSolutions