Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66367 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / rams
TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.
DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.
| Is This Answer Correct ? | 13 Yes | 21 No |
Post New Answer View All Answers
How would you determine who has added a row to a table?
What is auto invoicing? Explain : oracle accounts receivable
types of receipts and detail desription about recipts and tables effected by receipts?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What Are Cross Validation & Adi?
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.
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
What view would you use to determine free space in a tablespace?
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?
what is semphore explian it?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
