Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 67155 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
What is autocashrule set? : oracle accounts receivable
What is the mandatory setup in cyclecount ?
as a technical developer in oracle applications which type errors feced in your experience sofar
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What are different types of transactions in ar? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Could you please let me know the interfaces in OM / FA??
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
3. Steps in UAT?
