What is the difference between DELETE and TRUNCATE?
Answer Posted / kalyana chakravarthy
Delete is associated with rollback segments like U can undo
it before committing and U have a choice of deleting a
specific row or rows where as
Truncate is not associated with rollback segments ie U cant
undo it and U cant delete a row/rows of ur choice
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How do I kill a query in postgresql?
How do you optimize a stored procedure in sql?
Explain the purpose of %type and %rowtype data types with the example?
What is difference between hql and sql?
What is difference between primary and secondary key?
How do you use join?
What is the least restrictive isolation level? : Transact sql
What is the current version of postgresql?
explain primary keys and auto increment fields in mysql : sql dba
What is the example of procedure?
what are date and time data types in mysql? : Sql dba
What is a database trigger?
What is the use of triggers?
Is big data nosql?
What is not null in sql?