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?
belongs to collection: DBMS - DISTRIBUTED DATABASES MCQ
DBMS - DISTRIBUTED DATABASES MCQ
- A distributed database has which of the following advantages over a centralized database?
- An autonomous homogenous environment is which of the following?
- A transaction manager is which of the following?
- Location transparency allows for which of the following?
- A heterogeneous distributed database is which of the following?
- Some of the columns of a relation are at different sites is which of the following?
- Which of the following is true concerning a global transaction?
- A homogeneous distributed database is which of the following?
- Replication should be used when which of the following exist?
- Storing a separate copy of the database at multiple locations is which of the following?
- A distributed database is which of the following?
- A semijoin is which of the following?
- Which of the following is a disadvantage of replication?
- A distributed database can use which of the following strategies?
- Which of the following is not one of the stages in the evolution of distributed DBMS?
- A distributed transaction can be ............. if queries are issued at one or more nodes
- Depending on the situation each node in the Distributed Database system can act as, _________
- Which transaction contains statements that access more than one node?
- 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?
- Stored procedures have which of the following advantages?
- Which of the following is true concerning QBE?
- Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
- Which of the following statements is true concerning JDBC?
- A characteristic of a file server is which of the following?
- Three-tier architecture includes which of the following?
- A database server is responsible for which of the following?
- A benefit of the three-tier architecture is which of the following?
- Which of the following statements is true about symmetric multiprocessing?
- Client/server security includes which of the following?
- An application program interface (API) is which of the following?
- Which of the following items are not necessary for client/server?
- The three different application logic components are which of the following?
- Which of the following is true concerning the mainframe?
- A server cannot serve on which of the following levels?
- Websites without a database attached to them have which of the following characteristics?
- Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?
- An intranet provides which of the following?
- A proxy server is used for which of the following?
- What is Hypertext Transfer Protocol (HTTP)?
- XML is which of the following?
- A server-side extension is needed to do what?
- Client-side extensions:
- Which of the following is true concerning Web services standards?
- Which of the following is true about Microsoft Active Server Pages (ASP)?
- Features of XML include which of the following?
- An intrusion detection system does not perform which of the following?
- Web servers should be configured in which of the following ways?
- A homogenous distributed database is which of the following?
- A _____ DBMS distributes data processing tasks between the workstation and a network server
Database
(c).Two-phase commit
need an explanation for this answer? contact us directly to get an explanation for this answer