What is difference between TRUNCATE & DELETE?
- 16 Answers
- 39575 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / suman chakraborty
Truncate can not fire a trigger while delete can fire a
trigger
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What are sql*plus environment variables?
Do prepared statements prevent sql injection?
What is the difference between an inner and outer join?
What are inner outer left and right joins in sql?
What's the difference between a primary key and a clustered index?
Why are cursors used?
What is optimistic concurrency control? : Transact sql
What is the mutating table and constraining table?
List different type of expressions with the example.
Write a sql query to convert all character to uppercase after hypen.
Which is faster union or join?
Mention what are the benefits of pl/sql packages?
What is auto increment?
Which join is like inner join?
What is hibernate and its relation to sql?
