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

Monday, 26 July 2021

Distributed database and parallel database quiz questions with answers SET 09

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

MCQ in Distributed and Parallel Database with Solutions

1. Which of the following parallelism enables the execution of multiple queries generated by concurrent transactions?

(a) Inter-query parallelism

(b) Intra-query parallelism

(c) Independent parallelism

(d) None of the above.

Click here to view answer and explanation


 

2. Why data fragmentation and distribution is considered as a desirable property?

(a) Reduced data transmission cost

(b) Reduces table size

(c) Availability

(d) All of the above.

Click here to view answer and explanation


 

3. Suppose the users of a distributed database system are permitted to execute read-only queries. Which of the following would be the best solution for such an access?

(a) Horizontal fragmentation

(b) Vertical fragmentation

(c) Replication

(d) None of the above.

Click here to view answer and explanation


 

4. In some cases of query processing, the operations in a single query are executed at the same time or in random order. What type of parallelism is this? Choose the most relevant one from the following;

(a) Intra-operation parallelism

(b) Pipelined parallelism

(c) Independent parallelism

(d) Inter-operation parallelism

Click here to view answer and explanation


 

5. In distributed database environment, the execution of set of distributed transactions is said to be serializable if an only if

(a) the execution of the set of transactions at each site is serializable

(b) the serialization orders of set of transactions at all the sites are identical

(c) the set of transactions that are not in serial order

(d) the serialization orders of set of transactions at all the sites are not identical

Click here to view answer and explanation


 

******************

Related links:

 

Distributed database multiple choice questions with answers

important quiz questions in DDB

one mark questions in distributed database for university examinations

 

 

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