implementation analyst interview questions shared by candidates
Difference between delete and truncate, questions based on skills mentioned in resume
Truncate for remove any row or any object from table, Delete for removing table permanently.
Truncate: 1. It is DDL Command. 2. Doesn't delete specific record. 3. Where keyword not supported. 4. Permanent Deletion. 5. Rollback not possible. 6. It is fast. 7. Reset Identity Property. Delete: 1. It is DML Command. 2. Possible to delete specific record 3. Where keyword is supported. 4. Temporary Deletion. 5. Roll back possible. 6. It is slow. 7. It is Reset identity property.