what is difference between delete and truncet ?
- 7 Answers
- 10426 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / karna
As of I know,we can roll back bothe delete and truncate
statements.but in case of delete statement logging of the
details in the log file takes more time,beacuse it logs the
details row by row in the page.
when it comes to truncate,all the rows will be logged at
the same time.
Please correct me,If I am wrong.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
How to produce such kind of file?
How to do Data size testing? Who does this testing (Developer or tester)?
What the various ways to tune a teradata query
After normalization, what are the conditions which have to keep in mind to de-normalize it?
Explain database partitioning.
What is a reference table in database?
Define stored procedure?
What is the role of driver manager?
What is dialect in database?
What are the advantages of views in a database?
What do you mean by database?
What is the difference between specialization and generalization?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
Can we use redis as database?
