Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15487 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
what are the types of connection load-balancing?
how can you record information about current session?
how does an oracle clusterware manage crs resources?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What would you do with an "in-doubt" distributed transaction?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Which autogrowth database setting is good? : sql server DBA
what functionality does oracle provide to secure sensitive information?
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
What are the recovery models for a database? : sql server DBA
Explain materialized views and how they are used.
What is the default fill factor value? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
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?
