Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 16002 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
Where do you find the default index fill factor and how to change it? : sql server DBA
What is transparent data encryption? : sql server DBA
what are the differences of where and if in SAS?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what are the performance views in an oracle rac environment?
how does an oracle clusterware manage crs resources?
who owns the operating system files created by the utl_file package?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is a user-defined lock?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the different types of indexes available in sql server? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
