Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66535 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / padmapriya
1) Delete create log files when it is deleted and occupy
more space of memory
Whereas Truncate will not create any log files and hence
much faster than delete.
2) Delete can be roll back whereas Truncate is autocommit.
3) When there is foreign key constraint even though there
is no data in child table Truncate cannot be done. only
when the constraint is dropped truncate can be executed.
Whereas though we have foreign key constraints if the child
table is deleted, then parent table can be deleted.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain prerequisites and post activities of oracle database installation
What view would you use to determine free space in a tablespace?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
Difference between transaction type and transaction sources. : oracle accounts receivable
what is semphore explian it?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
3. Steps in UAT?
HOW TO SPOT AHIERARCHY?
types of receipts and detail desription about recipts and tables effected by receipts?
