Question

What is the mechanism which guarantees that all database servers participating in a distributed transaction either all commit or all roll back the statements in the transaction?

a.

Commit

b.

Commit transaction

c.

Two-phase commit

d.

Three-phase commit

Posted under Distributed Databases DBMS

Answer: (c).Two-phase commit

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What is the mechanism which guarantees that all database servers participating in a distributed transaction either all commit or all roll back the statements in the transaction?

Add Comment

Similar Questions

Discover Related MCQs

Q. Stored procedures have which of the following advantages?

View solution

Q. Which of the following is true concerning QBE?

View solution

Q. Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?

View solution

Q. Which of the following statements is true concerning JDBC?

View solution

Q. A characteristic of a file server is which of the following?

View solution

Q. Three-tier architecture includes which of the following?

View solution

Q. A database server is responsible for which of the following?

View solution

Q. A benefit of the three-tier architecture is which of the following?

View solution

Q. Which of the following statements is true about symmetric multiprocessing?

View solution

Q. Client/server security includes which of the following?

View solution

Q. An application program interface (API) is which of the following?

View solution

Q. Which of the following items are not necessary for client/server?

View solution

Q. The three different application logic components are which of the following?

View solution

Q. Which of the following is true concerning the mainframe?

View solution

Q. A server cannot serve on which of the following levels?

View solution

Q. Websites without a database attached to them have which of the following characteristics?

View solution

Q. Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?

View solution

Q. An intranet provides which of the following?

View solution

Q. A proxy server is used for which of the following?

View solution

Q. What is Hypertext Transfer Protocol (HTTP)?

View solution

View All MCQs on Distributed Databases

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...