Advanced Database Management System - Tutorials and Notes: Quiz questions and answers in distributed database MCQ 07

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Sunday, 8 November 2020

Quiz questions and answers in distributed database MCQ 07

Distributed database quiz questions with answers, MCQ in distributed database, solved exam questions in distributed and parallel database, distributed query processing, data replication

Multiple Choice Questions with Answers in Distributed Database


1. In distributed query processing, which of the following layer activities are performed by central control site?

a) Query decomposition

b) Data localization

c) Global optimization

d) Distributed execution

Click here to view answer


2. Which of the following is NOT a step of query decomposition layer in distributed query processing?

a) Normalized query is analyzed semantically

b) Semantically correct query is simplified

c) Simplified calculus query is restructured as an algebraic query

d) The algebraic query is executed by the local sites

Click here to view answer


3. Which of the following is/are NOT locking protocols used in distributed DBMS environment?

a) Centralized 2PL

b) Primary copy 2PL

c) Rigorous 2PL

d) Majority locking based 2PL

Click here to view answer


4. Let us assume that in 2PC protocol a transaction coordinator failed after a decision is taken (to abort/commit) and shared among the participating sites. What should the coordinator do during restart (recovery)?

a) Abort the transaction in any case

b) Commit the transaction in any case

c) Commit/abort only if received all acknowledgements from participating sites

d) Cannot be decided by the coordinator on what to be done

Click here to view answer


5. Which of the following is NOT an advantage of data replication in distributed database?

a) Fast access to shared data

b) High availability

c) Reduced network traffic

d) Easy updating of data items

Click here to view answer



Related links:

Distributed database multiple choice questions with answers

important quiz questions in DDB

one mark questions in distributed database for university examinations

Why update is a complex operation in data replication distributed database strategy

Steps to be taken during recovery as per 2 phase commit 2PC

List down the steps involved in distributed database query processing


No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents