Difference between delete and truncate, questions based on skills mentioned in resume

Question

Sigiloso · Accepted Answer

Truncate for remove any row or any object from table, Delete for removing table permanently.

Rajeev Ranjan · Answer

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.

4th Quarter Technologies

Pergunta de entrevista da empresa 4th Quarter Technologies

Respostas da entrevista

Empresas seguidas

Buscas de vagas