Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15773 Views
- I also Faced
- E-Mail Answers
Answer Posted / taral desai
truncate is faster then delete... truncate don't generate
rollback. truncated data can't be recovered
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Explain about your sql server dba experience? : sql server DBA
what are the types of connection load-balancing?
what are the differences of where and if in SAS?
What is a correlated sub-query? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Which autogrowth database setting is good? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Where would you look for errors from the database engine?
how does an oracle clusterware manage crs resources?
