what is difference between delete and truncet ?
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
Display the employees whose salary is less than average salary.
What is the difference between database and server?
what is the full procedure for using store procedure in informatica7.1?
What is sharded database?
What is a database example?
What is a database string?
What are different types of joins used in?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
How does non-cluster index functions?
What is database server and how it works?
What advantages does DBMS have over traditional file systems?
What is a Transformation?
Why do we need distributed database?
What is the concept of Virtual field?
What is the best database?