Concurrency Control
Description: Concurrency control Test contains questions on Information Technology for IT certification and Database questions of Oracle | |
Number of Questions: 15 | |
Created by: Sharvani Hegde | |
Tags: Concurrency control in oracle Oracle test IT questions DB questions Java/Oracle /C/C++ Oracle |
When the user requests the execution of an application, which of the followings starts the whole transaction?
Which of the following RAID level refers striped set with distributed parity and block-interleaved distributed parity?
Which of the following databases described as the control file contains recovery metadata i.e. information about backups?
Which of the following areas is a directory that serves as the default storage area for files related recovery?
Which of the following nodes participating in the session tree instructs the commit point site to initiate the global commit of the transaction, if all nodes prepare successfully?
Which of the following locking mechanisms is used to lock at the fragment level?
Which of the following nodes participating in the session tree is responsible for coordinating the transaction among the nodes?
The activity of ensuring atomicity in the presence of transaction aborts is called __________________.
Which of the following operations is performed to determine all non-committed transactions that have to be undone?
Two transactions are in which of the following mode, if they want to lock the same data item with shared and exclusive modes?
Which of the following RAID level refers block level parity and block-interleaved parity organization, uses block level striping?
Which of the following files is one way to automate scheduled backups through an operating system?
Which of the following nodes participating in the session tree that commits or rolls back the transaction, as instructed by the global coordinator?
Isolation property has to be strictly followed to avoid a problem called ______________.
The activity of providing serializability of the transaction is called ______________.