1. Delete:
- Purpose: To remove rows from a table based on specified conditions.
- Key Points:
- Deletes entire rows, not just specific attribute values.
- Works only on a table.
- Syntax:
![](https://i0.wp.com/easyexamnotes.com/storage/2024/02/delete.jpg?resize=1024%2C315&ssl=1)
2. Insert:
- Purpose: To add new data into a table.
- Key Points:
- Values must match the order of attributes and their specified domains.
- Syntax:
![](https://i0.wp.com/easyexamnotes.com/storage/2024/02/Insert.jpg?resize=1024%2C331&ssl=1)
3. Update:
- Purpose: To modify existing data in a table.
- Key Points:
- Changes the value of a specific column in a tuple.
- Syntax:
![](https://i0.wp.com/easyexamnotes.com/storage/2024/02/Update.jpg?resize=1024%2C331&ssl=1)