Computer Science - Database Systems - Discussion

Discussion Forum : Database Systems - Section 1 (Q.No. 6)
6.
After you _____ a record, many data management the environments require you to issue a command to save the changes you made.
Delete
Update
Sort key
Index
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
6 comments Page 1 of 1.

Mridul said:   4 months ago
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.

Tanmay said:   5 years ago
I think update is correct because add, delete, change, sort all come under update.

Mou said:   5 years ago
Why update? Please explain.

Jansi said:   9 years ago
Delete, update both are dml commands, after any changes done on dml commands. Explicitly user has to write commit statement.

Ankit mahajan said:   10 years ago
Why not after delete command?

Sandeep said:   1 decade ago
Why not after delete command?

Post your comments here:

Your comments will be displayed after verification.