Question

Which of the following is a disadvantage of replication?

a.

Reduced network traffic

b.

If the database fails at one site, a copy can be located at another site.

c.

Each site must have the same storage capacity.

d.

Each transaction may proceed without coordination across the network.

Posted under Distributed Databases DBMS

Answer: (c).Each site must have the same storage capacity.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which of the following is a disadvantage of replication?

Add Comment

Similar Questions

Discover Related MCQs

Q. A distributed database can use which of the following strategies?

View solution

Q. Which of the following is not one of the stages in the evolution of distributed DBMS?

View solution

Q. A distributed transaction can be ............. if queries are issued at one or more nodes.

View solution

Q. Depending on the situation each node in the Distributed Database system can act as, _________ .

View solution

Q. Which transaction contains statements that access more than one node?

View solution

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?

View solution

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

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!

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...