Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 14538 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
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
what do you understand by flashback feature of oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the default fill factor value? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What is a correlated sub-query? : sql server DBA
what is the use of ocr?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how can you implement fine-grained auditing?
What are the commands you'd issue to show the explain plan for "select * from dual"?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you schedule a job in database?
What types of replication are supported in sql server? : sql server DBA
what is grd?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
