DML
- Explain the difference between DELETE and TRUNCATE.
- Explain the difference between soft delete and hard delete.
- How do you delete records from a table in SQL?
- How do you insert data into a table in SQL?
- How do you perform bulk inserts in SQL?
- How do you update a record in a table?
- How do you update multiple columns in SQL?
- What are the pros and cons of using triggers in SQL databases?
- What is the difference between DELETE and TRUNCATE?
- What is the difference between DROP and DELETE?