Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11754 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
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
What is dialect in database?
What will happen non-clustered index will be created on clustered index?
How to do Data integrity testing? Who does this testing (Developer or tester)?
Write a query to get maximum and second maximum in oracle?
Explain storage manager?
How heap is implemented in database?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
Explain inner and outer joins with examples.
Define stored procedure?
Explain the field term used in database.
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
Explain phantom deadlock?
What is a database lookup?
How default key is different from primary key?
