Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66447 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / pravesh kumar
Truncate
1.Truncate Can be DDL Command.
2.it cannot be rollback.
3.we cann't use Where clause.
4.truncate=delete+commit so we cann't rollback.
5.truncate delete all record from the table.
6.truncate is a DDL command and cannot be rollbackand all
memory space is released back to server.
7.speed faster.
8.do not chcek constraint.
Delete
1.Delete Can be DML Command.
2.it can be rollback.
3.we can use Where clause.
4.delete=delete-- so we can be rollback.
5.delete delete record from the table.
6.truncate is a DDL command and can be rollback and all
memory space is not released back to server.
7.speed slow.
8. chcek constraint.
| Is This Answer Correct ? | 14 Yes | 7 No |
Post New Answer View All Answers
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
3. Steps in UAT?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Why more redos are generated when the oracle database is in begin backup mode?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
What is db_recovery_file_dest in oracle? When do you need to set this value?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What is the difference between conversions and interfaces? : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
types of receipts and detail desription about recipts and tables effected by receipts?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is the use of lockboxes? : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
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?
