> > Oracle MCQs > Oracle Distributed Transactions Concepts MCQs

Oracle Distributed Transactions Concepts MCQ

A system change number (SCN) is not an internal timestamp for a committed version of the database.

True

False

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

The database uses SCNs to coordinate distributed transactions among different databases. The database uses SCNs in which of the following ways?

All

The distributed transaction commits with the highest global SCN among all the databases involved

An application establishes a connection using a database line

The commit global SCN is sent to all databases involved in the transaction

Answer

Correct Answer: All

Note: This Question is unanswered, help us to find answer for this one

Distributed transactions can become in-doubt in which of the following way?

A server machine running Oracle Database software crashes

None

An unhandled software error does not occurs

A network connection between two or more Oracle Databases involved in distributed processing is connected

Answer

Correct Answer: A server machine running Oracle Database software crashes

Note: This Question is unanswered, help us to find answer for this one

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.

Database server

Commit point site

Local coordinator

Global coordinator

Answer

Correct Answer:

Global coordinator

Note: This Question is unanswered, help us to find answer for this one

When a node is told to prepare, it can respond in several ways, one of the ways is “no data on the node has been or can be modified, so no preparation is necessary”. This response is called as?

Abort

Read-only

Prepared

None

Answer

Correct Answer: Read-only

Note: This Question is unanswered, help us to find answer for this one

Which of the following are supported by transaction control statements?

Insert, Remove, Delete

Commit, Rollback, Savepoint

Alter,Execute,Drop

All

Answer

Correct Answer: Commit, Rollback, Savepoint

Note: This Question is unanswered, help us to find answer for this one

If all statements of a transaction reference to only a single remote node, then the transaction is remote and it is not distributed.

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

Select the correct case for which only queries are issued at one or more nodes.

Completely read-only without two-phase commit

Partially read-only

Completely read-only with prepare phase

None

Answer

Correct Answer: Partially read-only

Note: This Question is unanswered, help us to find answer for this one

Which condition is applied while determining the commit point site?

None

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

If a distributed transaction starts with a rollback, then the prepare and commit phases are not needed

A read-only node can be the commit point site

Answer

Correct Answer: 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

Note: This Question is unanswered, help us to find answer for this one

In the session tree what is the role that has a node which is forced to reference data on other nodes to complete its part of the transaction.

Client

Database server

Global coordinator

Local coordinator

Answer

Correct Answer: Local coordinator

Note: This Question is unanswered, help us to find answer for this one