1. Select the correct SQL statement for disabling recovery.
Answer
Correct Answer:
Alter system disable distributed recovery;
Note: This Question is unanswered, help us to find answer for this one
2. 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?
Answer
Correct Answer:
All
Note: This Question is unanswered, help us to find answer for this one
3. Give the exact reason for which you can force the failure of a distributed transaction.
Answer
Correct Answer:
To observe RECO automatically resolving the local portion of the transaction And To practice manually resolving in-doubt distributed transactions and observing the results
Note: This Question is unanswered, help us to find answer for this one
4. The job of the commit point site is to initiate a commit or roll back operation as instructed by _____________.
Answer
Correct Answer:
Global coordinator
Note: This Question is unanswered, help us to find answer for this one
5. Select the correct privilege which is required for manually committing an in-doubt transaction.
Answer
Correct Answer:
Force any transaction
Note: This Question is unanswered, help us to find answer for this one
6. You can roll back an in-doubt transaction to a savepoint?
Answer
Correct Answer:
No
Note: This Question is unanswered, help us to find answer for this one
7. 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.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
8. 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.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
9. The exact way for which distributed transactions can become in-doubt?
Answer
Correct Answer:
All
Note: This Question is unanswered, help us to find answer for this one
10. The indoubt transaction locks data that is required by other transactions. This situation occurs when the ORA-01591 error message interferes with user transactions.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
