What is difference between TRUNCATE & DELETE?
Answer Posted / deva
Truncate is a DDL command and hence cant be rolled back
where as delete is DML command and thus can be rolled back
if not necessary.
| Is This Answer Correct ? | 31 Yes | 3 No |
Post New Answer View All Answers
What are the various levels of constraints?
Can 2 queries be executed simultaneously in a distributed database system?
How can we optimize a sql query?
how to return query output in html format? : Sql dba
What is a database? Explain
Can two tables have same primary key?
Does sql between include endpoints?
Is truncate ddl or dml?
Can we change the table name in sql?
what is cross join? : Sql dba
What is pl sql collection?
what is query cache in mysql? : Sql dba
What are the types pl/sql code blocks?
What are the qualities of 2nf?
How would you convert date into julian date format?