Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15803 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
What is a system database and what is a user database? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
how can you get actual data change values from previous transactions in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is transparent data encryption? : sql server DBA
Why would you use sql agent? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can you connect from 10g user to 11g user??
what is asm?
What are the different sql server versions you have worked on? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
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 can you schedule a job in database?
What are the recovery models for a database? : sql server DBA
What is replication? : sql server DBA
