adplus-dvertising
frame-decoration

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 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 DBMS

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!

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Data Science

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

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

C Programming

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