What is the difference between DELETE and TRUNCATE?
Answer Posted / althaf
the delete command log all the stmts in the transaction log
and the truncate command dont log the stmts.
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
what is the difference between delete and truncate commands? : Sql dba
Explain unique key in sql.
What is write ahead logging in sql server?
What is the difference between jpql and sql?
what is sql profiler? : Sql dba
What is the primary use of normalization?
what is the difference between blob and text? : Sql dba
Mention what is the function that is used to transfer a pl/sql table log to a database table?
Can we write ddl statements in functions?
What is sql server and ase?
What are the subsets of sql?
Difference between table function and pipelined function?
What are different types of sql?
What do you understand by exception handling in pl/sql?
What does count (*) mean?