adplus-dvertising

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.

frame-decoration

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

Q11.
A distributed database is which of the following?

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.

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?

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.

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?

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.

Discuss
Answer: (c).Each site must have the same storage capacity.
Q14.
A distributed database can use which of the following strategies?

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

Discuss
Answer: (d).All of the above
Q15.
Which of the following is not one of the stages in the evolution of distributed DBMS?

a.

Unit of work

b.

Remote unit of work

c.

Distributed unit of Work

d.

Distributed request

Discuss
Answer: (a).Unit of work
Q16.
A distributed transaction can be ............. if queries are issued at one or more nodes.

a.

fully read-only

b.

partially read-only

c.

fully read-write

d.

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.

A client

b.

A server

c.

Both A & B

d.

None of the above

Discuss
Answer: (c).Both A & B
Q18.
Which transaction contains statements that access more than one node?

a.

A Remote Transaction

b.

A Distributed transaction

c.

Both A & B

d.

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?

a.

Commit

b.

Commit transaction

c.

Two-phase commit

d.

Three-phase commit

Discuss
Answer: (c).Two-phase commit
Q20.
Stored procedures have which of the following advantages?

a.

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

b.

Network traffic increases

c.

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

d.

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

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!

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Data Science

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

Discrete Mathematics

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

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

SQL Server

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

Computer Graphics

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

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...