Answer these Oracle Distributed Transactions Concepts MCQs and see how sharp is your knowledge of Oracle Distributed Transactions Concepts.
Scroll down and let's start!
A. Client
B. Database server
C. Global coordinator
D. Local coordinator
A. None
B. If multiple nodes directly referenced by the global coordinator have the same commit point strength, then the database designates one of these as the commit point site
C. If a distributed transaction starts with a rollback, then the prepare and commit phases are not needed
D. A read-only node can be the commit point site
A. Completely read-only without two-phase commit
B. Partially read-only
C. Completely read-only with prepare phase
D. None
A. True
B. False
A. Insert, Remove, Delete
B. Commit, Rollback, Savepoint
C. Alter,Execute,Drop
D. All
A. Abort
B. Read-only
C. Prepared
D. None
Which of the following performs the following operations during a distributed transaction?
1) Sends all of the distributed transaction SQL statements, remote procedure calls, and so forth to the directly referenced nodes, thus forming the session tree.
2) Instructs all directly referenced nodes other than the commit point site to prepare the transaction.
3) Instructs the commit point site to initiate the global commit of the transaction if all nodes prepare successfully.
A.
Database server
B.
Commit point site
C.
Local coordinator
D.
Global coordinator
A. A server machine running Oracle Database software crashes
B. None
C. An unhandled software error does not occurs
D. A network connection between two or more Oracle Databases involved in distributed processing is connected
A. All
B. The distributed transaction commits with the highest global SCN among all the databases involved
C. An application establishes a connection using a database line
D. The commit global SCN is sent to all databases involved in the transaction
A. True
B. False