Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11442 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
What happens when shared and exclusive locks are applied on data item?
What does currency type mean in database?
A lowest level of security by most RDBMS is
What is a super key?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What is a database example?
What are the advantages of views in a database?
Explain partial key?
How much does it cost to build a database?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
Explain file manager?
WHAT IS CARDINALITIES OF JOIN?
issues involved in modeling and building data werahouses
How do database connections work?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
