Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25118 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
How do I order columns in sql?
Can we join more than 2 tables in sql?
How to use sql*plus built-in timers?
Can triggers stop a dml statement from executing on a table?
Explain ddl statements in pl/sql?
What is the primary use of normalization?
write an sql query to find names of employee start with 'a'? : Sql dba
Why truncate is faster than delete?
Can a foreign key be a duplicate?
Can we call stored procedure in function?
How can we solve sql error: ora-00904: invalid identifier?
What is %s in sql?
What is information schema in sql?
Define tables and fields in a database
What mean sql?
