Multiple Choice Questions MCQ on Distributed Database

Multiple Choice Questions MCQ on Distributed Database with answers

Distributed Database – Multiple Choice Questions with Answers

1. Let us suppose that in a distributed database, during a transaction T1, one of the sites, say S1, is failed. When recovers, the site S1 has to check its log file (log based recovery) to decide the next move on the transaction T1. If the log contains a <commit T> record, what the site S1 has to do?

a) Need not do anything

b) Perform Undo

c) Perform Redo

d) Abort the transaction

2. Global Wait-for graph is used for ________________  in Distributed database.

a) Handling concurrency control

b) Handling failures

c) Handling deadlock

d)  None of the above

3. In Distributed database, ______________ are the transactions for which a <ready T> log is found in the log file, but neither a <commit T> log nor an <abort T> log is found.

a) In-doubt transactions

b) Serialized transactions

c) Cascadeless transactions

d) Distributed transactions

4. While using commit protocols for handling atomicity issues, the distributed database system may enter into a situation called Blocking problem. Which of the following commit protocols can avoid Blocking problem?

a) Two-phase commit protocol

b) Three-phase commit protocol

c) Both of the above

d) None of the above

5. Which of the following concurrency control protocol is suitable for an application where frequency of read operation is much greater than that of write operation?

a) Majority protocol

b) Quorum-consensus protocol

c) Biased protocol

d) Single lock protocol

6. Which of the following parallel database architectures is/are mainly used by distributed database system?

a) Shared Memory

b) Shared Disk

c) Shared Nothing

d) Hierarchical

7. Which of the following is not a promise of distributed database?

a) Network Transparency

b) Replication Transparency

c) Fragmentation Transparency

d) None of the above

8. All sites in a distributed database commit at exactly the same instant. TRUE/FALSE

a) TRUE

b) FALSE

9. The real use of the Two-phase commit protocol is  ______________

a) Deadlock will not occur

b) Concurrency control can be avoided

c) Atomicity, i.e, all-or-nothing commits at all sites

d) None of the above

10. Read one, write all available protocol is used to increase ___________ in a distributed database system.

a) Availability

b) Robustness

c) Both Availability and Robustness

d) Neither Availability nor Robustness

**********

Related links:

• Go to Distributed Database Quiz page

• Go to Database Management Systems Quiz page

• Go to Distributed Database Home page

Distributed database multiple choice questions with answers

important quiz questions in DDB

one mark questions in distributed database for university examinations