Question

Replication should be used when which of the following exist?

a.

When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.

b.

When using many nodes with different operating systems and DBMSs and database designs.

c.

The application's data can be somewhat out-of-date.

d.

All of the above.

Posted under Distributed Databases DBMS

Answer: (c).The application's data can be somewhat out-of-date.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Replication should be used when which of the following exist?

Add Comment

Similar Questions

Discover Related MCQs

Q. Storing a separate copy of the database at multiple locations is which of the following?

View solution

Q. A distributed database is which of the following?

View solution

Q. A semijoin is which of the following?

View solution

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

View solution

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

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!

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

Data Science

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

Python

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

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

Internet of Things (IoT)

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

Digital Image Processing (DIP)

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

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...