Computer Science - Database Systems - Discussion

The other options don't quite fit the context:

1. **Delete**: Deleting a record typically removes it entirely from the data, so there's no need to issue a command to save changes because the record is gone.

2. **Sort key**: Sorting typically involves reordering records but doesn't change the actual data within a record, so there's no need to save changes after sorting.

3. **Index**: Creating or modifying an index helps with data retrieval but doesn't directly modify the data in the records, so saving changes doesn't apply to index operations.

So, "Update" is the appropriate term for making changes to the data within a record and then saving those changes.

Delete, update both are dml commands, after any changes done on dml commands. Explicitly user has to write commit statement.

I think update is correct because add, delete, change, sort all come under update.

Why not after delete command?

Why not after delete command?

Why update? Please explain.