Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11744 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / prabhanjan
1)Truncate will perform faster then delete.
2)When we truncate table triggers will not fire on delete
event.Where as for delete triggers will fire
3)After truncate table we can't roll back.
But for Delete we can roll back
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain entity ?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
What is the role of tester in discovery(in Checklist)?
What is ole db source in ssis?
What is lagging in DBMS ?
What advantages does DBMS have over traditional file systems?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
what is tkprof tool and how it is used???
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
Explain storage manager?
What is the concept of Virtual field?
What are different types of data models available? Explain with example?
What is relational database with example?
What is odm in database?
how can we view column head in first page but not in remaining pages?
