what is difference between delete and truncet ?
- 7 Answers
- 9650 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
After normalization, what are the conditions which have to keep in mind to de-normalize it?
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
A lowest level of security by most RDBMS is
How is image stored in database?
What is the database url?
Explain buffer manager?
Explain the various types of normalization.
Is redis in memory database?
What the various ways to tune a teradata query
What are different types of clusters present?
How many indexes can be created on a table?
What is table scan and index scan?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What is the Difference Primary key and Unique Key
What is database client?
