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!

Data Warehousing and OLAP

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

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Hadoop

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

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...