10 Questions Total

Distributed Databases MCQs

Topic-wise practice questions for Database Management Systems. Test your knowledge, check solutions on demand, and pace your preparation.

Zero-leak answer engine • Rate-limited explanations

Practice in Timed Mode

Q1medium

A user executes the following query in a distributed environment. If the system possesses Location Transparency, what is true about the user's knowledge? distributed-shell


SELECT name, balance
FROM Global_Accounts

Discuss on Board

Q2medium

A global retail company stores its Inventory table across three servers: Tokyo, London, and New York. The Tokyo server only contains rows where region = 'Asia'. What specific type of distributed database design is this?

Discuss on Board

Q3medium

Why would a database designer choose Vertical Fragmentation for a


Personnel table?

Discuss on Board

Q4medium

A social media application uses Eventual Consistency for "Likes" on a post. A user in London likes a post, but a user in Sydney doesn't see that like for another 2 seconds. Which property of a distributed system is being prioritized here?

Discuss on Board

Q5easy

What is the primary disadvantage of Synchronous (Eager) Replication compared to Asynchronous (Lazy) Replication?

Discuss on Board

Q6easy

In a Heterogeneous Distributed Database System, which of the following is true?

Discuss on Board

Q7hard

(Logic/Calculation) A distributed query requires joining Table A (Node 1) and Table B (Node 2). To minimize network traffic, the DBMS sends only the unique Join-Keys from Table A to Node 2, filters Table B there, and sends back only the matching rows. What is this optimization technique called?

Discuss on Board

Q8easy

What is the primary role of the Transaction Coordinator in a distributed database?

Discuss on Board

Q9medium

According to the CAP Theorem, if a network partition occurs (nodes cannot communicate), a database that chooses to remain Available (A) must sacrifice which of the following?

Discuss on Board

Q10hard

A bank is performing a distributed transaction to transfer money between a branch in Karachi and a branch in Islamabad. The Two-Phase Commit (2PC) protocol is used. If the Karachi node sends a "REDO" (Ready to Commit) message but the Islamabad node sends an "ABORT" message during the first phase, what happens?

Discuss on Board