Welcome to the Distributed Databases MCQs Page

Dive deep into the fascinating world of Distributed Databases with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Distributed Databases, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of Distributed Databases, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

Check out the MCQs below to embark on an enriching journey through Distributed Databases. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Distributed Databases. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Distributed Databases MCQs | Page 2 of 5

Explore more Topics under DBMS

01

DBMS Basics

02

Data Models

03

The Entity Relationship Approach

04

Relational Databases

05

Data Storage and Querying

06

Relational Algebra

07

Normalization

08

Storage and File Structures

09

Indexing and Hashing

10

Transactions

11

Concurrency Control

12

Recovery System

13

SQL

14

Data Warehousing and Data Mining

15

RDBMS

16

Advanced SQL

17

SQL Queries,Constraints and Triggers

Q11.

A distributed database is which of the following?

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

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

A single logical database that is limited to one location.

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

Discuss

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

Q12.

A semijoin is which of the following?

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

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

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

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

Discuss

Answer: (c).Only the joining attributes are sent from one site to another and then only the required rows are returned.

Q13.

Which of the following is a disadvantage of replication?

Reduced network traffic

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

Each site must have the same storage capacity.

Each transaction may proceed without coordination across the network.

Discuss

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

Q14.

A distributed database can use which of the following strategies?

Totally centralized at one location and accessed by many sites

Partially or totally replicated across sites

Partitioned into segments at different sites

All of the above

Discuss

Answer: (d).All of the above

Q15.

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

Unit of work

Remote unit of work

Distributed unit of Work

Distributed request

Discuss

Answer: (a).Unit of work

Q16.

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

fully read-only

partially read-only

fully read-write

partially read-write

Discuss

Answer: (b).partially read-only

Q17.

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

A client

A server

Both A & B

None of the above

Discuss

Answer: (c).Both A & B

Q18.

Which transaction contains statements that access more than one node?

A Remote Transaction

A Distributed transaction

Both A & B

None of the above

Discuss

Answer: (b).A Distributed transaction

Q19.

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?

Commit

Commit transaction

Two-phase commit

Three-phase commit

Discuss

Answer: (c).Two-phase commit

Q20.

Stored procedures have which of the following advantages?

It takes a longer time to write them as compared to writing Visual Basic.

Network traffic increases

Data integrity improves as multiple applications access the same stored procedure.

Result in thicker client and thinner database server.

Discuss

Answer: (c).Data integrity improves as multiple applications access the same stored procedure.

Page 2 of 5

Welcome to the Distributed Databases MCQs Page

Distributed Databases MCQs | Page 2 of 5

Explore more Topics under DBMS

DBMS Basics

Data Models

The Entity Relationship Approach

Relational Databases

Data Storage and Querying

Relational Algebra

Normalization

Storage and File Structures

Indexing and Hashing

Transactions

Concurrency Control

Recovery System

SQL

Data Warehousing and Data Mining

RDBMS

Advanced SQL

SQL Queries,Constraints and Triggers

Suggested Topics

DBMS

Cryptography and Network Security

Object Oriented Programming Using C++

Java Spring Framework

Wireless and Mobile Communications

UNIX

Data Warehousing and OLAP

Artificial Intelligence

C Programming