Before commit work in DBMS :
2016
Before commit work in DBMS :
- A.
The changes you made are not visible to you nor to other developers of the database instant.
- B.
The changes you made are visible to you and to other developers of the database instant.
- C.
The changes you make are not final, but you can not do it with rollback statement as before.
- D.
The changes made by you are visible only to you, but not to others users of the database instant.
Attempted by 10 students.
Show answer & explanation
Correct answer: D
Before a COMMIT statement is executed in a DBMS, any data modifications made within the current transaction are saved in a temporary buffer. These changes are visible exclusively to the user session that performed them and remain completely hidden from other database users until permanently saved. Therefore, Option D is correct.