What happens when a database transaction triggers a 'COMMIT' statement?
A. The transaction pauses temporarily.
B. The database structure is dropped.
C. All changes made by the transaction are made permanent on disk storage.
D. The transaction is aborted and wiped.
Answer: Option C
Solution (By JKSSB Mock Tests)
Executing a COMMIT statement instructs the database engine to save all data updates performed during the transaction permanently into physical storage.
No comments yet. Be the first to start the discussion!