Database Transactions Multiple Choice Questions (MCQ) PDF Download

MCQ 1: Once a transaction has executed commit work, its effects can no longer be undone by

1. Trace work
2. Transmit work
3. Rollback work
4. Traceback work

MCQ 2: In the case of power outage or other system crash, when the system restarts, the action known to be occur is of

1. Rollback work
2. Trace work
3. Traceback work
4. Commit work

MCQ 3: All the statements between the keywords begin atomic ...end form a/an

1. Single transaction
2. NO transaction
3. Multiple transactions
4. 2 parallel transactions only

MCQ 4: The rollback work cannot undo, once a transaction has executed by the

1. Commit work
2. Traceback work
3. Trace work
4. Transmit work

MCQ 5: How to turn off automatic commit depends on the specific

1. Database system
2. Queries execution
3. SQL implementation
4. Structure design