Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.
Select an option to see the answer and solution.
Database · all questionsDistributed Databases
Distributed Databases
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
30
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites.
Select an option to see the answer and solution.
Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network.
Select an option to see the answer and solution.
A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.
Select an option to see the answer and solution.
The purpose of timestamping is to avoid the use of locks.
Select an option to see the answer and solution.
Data replication is favored where most process requests are read-only and where the data are relatively static.
Select an option to see the answer and solution.
The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex.
Select an option to see the answer and solution.
The semijoin approach saves network traffic.
Select an option to see the answer and solution.
In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.
Select an option to see the answer and solution.
The problem of concurrency control is more complex in a distributed database.
Select an option to see the answer and solution.