Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 14536 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh
Basically truncate is a DDL and Delete is DML. You can use
delete to remove rows depending on certain criteria and it
generated redo logs and can be rolled back before you
commit the transaction, Where as the truncate is used to
remove all the data in the table. Once you execute this
command u can not rollback this transaction.and commit is
not required for the truncate statement
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what is the diffrence between core dba and apps dba?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is a system database and what is a user database? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the steps you will take to improve performance of a poor performing query?
how can you find out if a table can be redefined?
who owns the operating system files created by the utl_file package?
what is the use of ocr?
Which autogrowth database setting is good? : sql server DBA
how can you initialize log miner?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
