Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66492 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amit
In Truncate only data are remove from table
where as in delete structure of table are delete.
| Is This Answer Correct ? | 3 Yes | 9 No |
Answer / 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 |
what is domain in database and its benefits?
Describe the P2P cycle ?
Give the two types of tables involved in producing a star schema and the type of data they hold.
what is difference between inner join & nested query or subqueries
What is Virtual Memory?
What are the mandatory setups in setting up a PO in oracle
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Explain how to close periods in ar. : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
What is index? How many types of indexes?
Oracle General 
