Here are the collections of multiple choice questions on Oracle distributed transaction management. It includes MCQ questions on fundamentals of Oracle distributed transaction management, concurrency control, schedule, transaction recovery, and recovery management.
1) A mechanism which ensures that simultaneous execution of more than one transaction does not lead to any database inconsistencies is called ……………… mechanism.
A. transaction control
B. transaction management
C. concurrency parallelism
D. concurrency control
2) The transaction wants only to read the data item of the mode is called as …….
A. Exclusive Mode
B. Shared Mode
C. Inclusive Mode
D. Unshared Mode
3) Any execution of a set of transactions is called as its ………
A. non-serial schedule
B. serial schedule
C. schedule
D. interleaved schedule
4) ………… is a program or set of program that interacts with the database at some point in its execution.
A. A database system
B. A database application
C. Both
D. none
5) ………. component of a database is responsible for ensuring atomicity and durability.
A. recovery management
B. concurrency control
C. storage management
D. query evaluation engine
6) The activity of ensuring atomicity in the presence of Transaction aborts is called ……….
A. transaction control
B. transaction management
C. transaction recovery
D. concurrency control
7) A ………….is a set of rules that state when a transaction may lock or unlock each of the data items in the database
A. concurrency control
B. transaction control
C. validation control
D. locking protocol
8) ……………… is a collection of programs performing all necessary action associated with a database.
A. Database associated
B. Database administrator
C. Database application
D. Database management system
9) Which protocol permits the release of exclusive locks only at the end of the transaction?
A. Graph-based protocol
B. The strict two-phase locking protocol
C. Two-phase locking protocol
D. Rigorous Two-phase locking protocol
10) The activity of providing Durability of the transaction is called …..
A. database control
B. transaction management
C. transaction recovery
D. database recovery
11) Which protocol allows a transaction to lock a new data item only if that transaction has not yet unlocked data item?
A. Graph-based protocol.
B. The strict two-phase locking protocol
C. Two-phase locking protocol
D. Timestamp ordering scheme
12) ………. is a collection of application programs that interact with the database along with DBMS.
A. A database system
B. A database application
C. Database administration
D. Data system
13) …….. ensures that once the transaction completes successfully, the results of the operations become permanent.
A. serializability
B. synchronizability
C. atomicity
D. durability
14) A ……. contains information for undoing or redoing all the actions performed by the transactions.
A. save point
B. log
C. node
D. commit_point
15) A …………. is a unit of program execution that accesses and possibly updates various data items.
A. DBMS
B. monitor
C. transaction
D. transistor
16) A transaction is an action used to perform some manipulation on data stored in the ……..
A. Memory
B. Record
C. Database
D. All of these
17) A transaction is terminated if it has ……..
A. aborted
B. committed
C. running state
D. aborted or committed
18) The two possible communication errors are, Lost messages and …….
A. Network Partitions
B. Lost acknowledgment
C. Timeout
D. log error
19) The only way to undo the effects of a committed transaction is to execute a …….
A. committed transaction
B. compensating transaction
C. supplementary transaction
D. update query
20) In ………., one or more users/programs attempt to access the same data at the same time.
A. concurrency
B. transaction control
C. locking
D. two-phase locking
Answers:
1) D. concurrency control
2) B. Shared Mode
3) C. schedule
4) B. A database application
5) A. recovery management
6) C. transaction recovery
7) D. locking protocol
8) D. Database management system
9) B. Strict two-phase locking protocol
10) D. database recovery
11) C. Two-phase locking protocol
12) A. A database system
13) D. durability
14) B. log
15) C. transaction
16) C. Database
17) C. running state
18) A. Network Partitions
19) B. compensating transaction
20) A. concurrency
Read Next: MCQ on Distributed Database Transaction Management set-4
Read More: Collections of DBMS MCQ questions
Download: Free PDF E-book of DBMS MCQ questions
Comments are closed.