Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15486 Views
- I also Faced
- E-Mail Answers
Answer Posted / sridhar
truncate and delete are deltes all rows in the table but truncate is much faster than delete.
and if u delete row in the delte deletion of each gets logged in the transaction log.
truncate there is no way to log in transaction log
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How would you best determine why your MVIEW couldn't FAST REFRESH?
what do you understand by flashback feature of oracle?
What are the different types of indexes available in sql server? : sql server DBA
What are the commands used in dcl? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can you record information about current session?
How do you open a cluster administrator? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what is a user-defined lock?
how can a session indicate its interest in receiving alerts?
Why would you call update statistics? : sql server DBA
what are the performance views in an oracle rac environment?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
internal architecture
