Database Developer Question:
Download Job Interview Questions and Answers PDF
Tell us what is the difference between Delete, Truncate and Drop command?
Answer:
The difference between the Delete, Truncate and Drop command is
☛ Delete command is a DML command, it is used to delete rows from a table. It can be rolled back.
☛ Truncate is a DDL command, it is used to delete all the rows from the table and free the space containing the table. It cant be rolled back.
☛ Drop is a DDL command, it removes the complete data along with the table structure(unlike truncate command that removes only the rows). All the tables’ rows, indexes, and privileges will also be removed.
☛ Delete command is a DML command, it is used to delete rows from a table. It can be rolled back.
☛ Truncate is a DDL command, it is used to delete all the rows from the table and free the space containing the table. It cant be rolled back.
☛ Drop is a DDL command, it removes the complete data along with the table structure(unlike truncate command that removes only the rows). All the tables’ rows, indexes, and privileges will also be removed.
Download Database Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Do you know SQL Data Types? | Tell me what are aggregate functions in SQL? |