What is difference between TRUNCATE & DELETE?
Answer Posted / amedela chandra sekhar
Truncate Delete
1)it is DDl command it is DML command
2)it delete records permanently it delete records temporarly
we can't roll back we can roll back the data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Enlist the advantages of sql.
Is json a nosql?
How are sql commands classified?
Is ms sql traffic encrypted?
What is exit statement?
What is natural join in sql?
How do you know if a relationship is 2nf?
What are all types of user defined functions?
What is offset and limit in sql?
Is sql better than excel?
What is the current version of postgresql?
How do you define a foreign key?
How to move files from one directory to another in pl sql?
what is a composite primary key ? : Sql dba
How to change sql*plus system settings?