Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15797 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
How would you go about verifying the network name that the local_listener is currently using?
what functionality does oracle provide to secure sensitive information?
internal architecture
what is the diffrence between core dba and apps dba?
Why does Oracle not permit the use of PCTUSED with indexes?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
how can you initialize log miner?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
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 purpose does the model database server? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : 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?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you find out if a table can be redefined?
