Home - Database - Distributed Databases

Distributed Databases Online Exam Quiz

Important questions about Distributed Databases. Distributed Databases MCQ questions with answers. Distributed Databases exam questions and answers for students and interviews.

1. A semijoin is which of the following?

Options

A : Only the joining attributes are sent from one site to another and then all of the rows are returned.

B : All of the attributes are sent from one site to another and then only the required rows are returned.

C : Only the joining attributes are sent from one site to another and then only the required rows are returned.

D : All of the attributes are sent from one site to another and then only the required rows are returned.

2. A heterogeneous distributed database is which of the following?

Options

A : The same DBMS is used at each location and data are not distributed across all nodes.

B : The same DBMS is used at each location and data are distributed across all nodes.

C : A different DBMS is used at each location and data are not distributed across all nodes.

D : A different DBMS is used at each location and data are distributed across all nodes.

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

Options

A : Data Replication

B : Horizontal Partitioning

C : Vertical Partitioning

D : Horizontal and Vertical Partitioning

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

Options

A : Unit of work

B : Remote unit of work

C : Distributed unit of Work

D : Distributed request

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

Options

A : Totally centralized at one location and accessed by many sites

B : Partially or totally replicated across sites

C : Partitioned into segments at different sites

D : All of the above

6. Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.

Options

A : True

B : False

C :

D :

7. Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.

Options

A : True

B : False

C :

D :

8. A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.

Options

A : True

B : False

C :

D :

9. The purpose of timestamping is to avoid the use of locks.

Options

A : True

B : False

C :

D :

10. The problem of concurrency control is more complex in a distributed database.

Options

A : True

B : False

C :

D :

1. An autonomous homogenous environment is which of the following?

Options

A : The same DBMS is at each node and each DBMS works independently.

B : The same DBMS is at each node and a central DBMS coordinates database access.

C : A different DBMS is at each node and each DBMS works independently.

D : A different DBMS is at each node and a central DBMS coordinates database access.

2. A transaction manager is which of the following?

Options

A : Maintains a log of transactions

B : Maintains before and after database images

C : Maintains appropriate concurrency control

D : All of the above.

3. A distributed database is which of the following?

Options

A : A single logical database that is spread to multiple locations and is interconnected by a network

B : A loose collection of file that is spread to multiple locations and is interconnected by a network

C : A single logical database that is limited to one location.

D : A loose collection of file that is limited to one location.

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

Options

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.

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

Options

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.

6. A homogenous distributed database is which of the following?

Options

A : The same DBMS is used at each location and data are not distributed across all nodes.

B : The same DBMS is used at each location and data are distributed across all nodes.

C : A different DBMS is used at each location and data are not distributed across all nodes.

D : A different DBMS is used at each location and data are distributed across all nodes.

7. Some of the columns of a relation are at different sites is which of the following?

Options

A : Data Replication

B : Horizontal Partitioning

C : Vertical Partitioning

D : Horizontal and Vertical Partitioning

8. Location transparency allows for which of the following?

Options

A : Users to treat the data as if it is at one location

B : Programmers to treat the data as if it is at one location

C : Managers to treat the data as if it is at one location

D : All of the above.

9. A distributed database has which of the following advantages over a centralized database?

Options

A : Software cost

B : Software complexity

C : Slow Response

D : Modular growth

10. Which of the following is true concerning a global transaction?

Options

A : The required data are at one local site and the distributed DBMS routes requests as necessary.

B : The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.

C : The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.

D : The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

Database more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.02591609954834