Managing Oracle Distributed Transactions MCQs
Managing Oracle Distributed Transactions MCQs
Answer these Managing Oracle Distributed Transactions MCQs and assess your grip on the subject of Managing Oracle Distributed Transactions.
Scroll below and get started!
1: The indoubt transaction locks data that is required by other transactions. This situation occurs when the ORA-01591 error message interferes with user transactions.
A. True
B. False
2: The exact way for which distributed transactions can become in-doubt?
A. All
B. An unhandled software error occurs
C. A server machine running Oracle Database software crashes
D. A network connection between two or more Oracle Databases involved in distributed processing is disconnected
3: The in-doubt transaction locks data that is required by other transactions and this situation occurs when the ORA-01591 error message interferes with user transactions.
A. True
B. False
4: RECO can use an existing connection or establish a new connection to other nodes involved in the failed transaction. When a connection is established, RECO automatically resolves all in-doubt transactions.
A. False
B. True
5: You can roll back an in-doubt transaction to a savepoint?
A. Yes
B. No
6: Select the correct privilege which is required for manually committing an in-doubt transaction.
A. System privilege And Force any transaction
B. None
C. Force any transaction
D. SYSTEM PRIVILEGE
7: The job of the commit point site is to initiate a commit or roll back operation as instructed by _____________.
A. Local coordinator
B. Database servers
C. Global coordinator
D. Commit point site
8: Give the exact reason for which you can force the failure of a distributed transaction.
A. To observe RECO automatically resolving the local portion of the transaction And To practice manually resolving in-doubt distributed transactions and observing the results
B. None
C. To practice manually resolving in-doubt distributed transactions and observing the results
D. To observe RECO automatically resolving the local portion of the transaction
9: A DML statement that requires locks on a remote database can be blocked if any another transaction own locks on the requested data. If these locks continue to block the requesting SQL statement then which sequence of events occurs?
A. The database rolls back the statement
B. The database returns this error message to the use
C. All
D. A timeout occurs
10: Select the correct SQL statement for disabling recovery.
A. Update system disable distributed recovery;
B. Delete system disable distributed recovery;
C. Alter system disable distributed recovery;
D. Select system disable distributed recovery;
List of Managing Oracle Distri...
Available in:
Managing Oracle Distributed Transactions MCQs
