Master In Computer Science

Database Systems MCQs

CS: Database Systems MCQs - Subtopic

Database Transactions MCQ with Answers

Database Transactions Multiple Choice Questions (MCQ) to practice database transactions quiz answers PDF, database transactions worksheets for online degrees. Solve sql concepts and queries Multiple Choice Questions and Answers (MCQs), "Database Transactions Quiz Questions" and answers for computer software engineer online degree. Learn database transactions, dbms transactions, sql data types and schemas test prep for computer science associate degree.

"Once a transaction has executed commit work, its effects can no longer be undone by" Multiple Choice Questions (MCQ) on database transactions with choices trace work, transmit work, rollback work, and traceback work for computer software engineer online degree. Solve database transactions quiz questions for merit scholarship test and certificate programs for 2 year computer science degree.

MCQs on Database Transactions

1.

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

Trace work
Transmit work
Rollback work
Traceback work

2.

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

Rollback work
Trace work
Traceback work
Commit work

3.

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

Single transaction
NO transaction
Multiple transactions
2 parallel transactions only

4.

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

Commit work
Traceback work
Trace work
Transmit work

5.

How to turn off automatic commit depends on the specific

Database system
Queries execution
SQL implementation
Structure design