Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11785 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
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
What is the Lock Based Protocol used for?
sparse lookup and where its options we find in OCI and db2?
What is the use of graph database?
What is Object Oriented model?
Which is the best graph database?
How is image stored in database?
List some advantages of dbms.
What happens when shared and exclusive locks are applied on data item?
What is ole db source in ssis?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
List various types of log-based recovery in DBMS.
How to do performance tunning a database in DB2 V8.2 UDB in linux
Differentiate between unique key and foreign key?
What is the difference between data source and database?
