Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25197 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / babloo
when truncate command is issued, all the rows from the
table are deleted and the memory space occupied by the
table in the tablespace is also released whereas when
delete command is issued, only all the rows are deleted
fronm the table
| Is This Answer Correct ? | 28 Yes | 0 No |
Post New Answer View All Answers
can sql servers linked to other servers like oracle? : Sql dba
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is dcl in sql?
What is indexing oracle sql?
What are the types of subqueries?
How do I view an execution plan in sql?
Explain the difference between sql and mysql.
What is the difference between a subquery and a join?
Why are cursors used?
Can we write dml inside a function in sql server?
What is data control language (dcl)?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
How does stored procedure reduce network traffic?
What are aggregate functions in sql?
