Tuesday, June 24, 2014

Database System Architecures and Distributed Database - Quiz 2

Distributed Database and Database System Architectures - Quiz


1. Which of the following is more suitable for parallelizing a single query?
    Coarse-granularity parallelism
    Fine-granularity parallelism
    Both
    None of them

2. A regular desktop machine (with two to four processors) can be mentioned as ________________ machine.
    Fine-grain parallel
    Coarse-grain parallel
    Massively parallel
    None of the above

3. If we parallelize the execution of large number of small transactions in a database system, then which of the following would be increased?
    Response time
    Rotational latency
    Throughput
    All of the above

4. If the speed of a parallel system is N when the larger system has N times the resources of the smaller system, then the speedup is __________
    Linear Speedup
    Sublinear Speedup
    Superlinear Speedup
    None of the above

5. Which of the following can affect the speedup and scaleup of a database system?
    Startup costs
    Interference
    Skew
    All of the above

6. Which of the following situation would cause a skew?
    Huge amount of records in a table
    Even distribution of records in multiple sites
    Both
    None

7. In which of the following architectures memory bus is not a bottleneck?
    Shared memory and shared disk
    Shared disk and shared nothing
    Shared memory and shared nothing
    All of the above

8. Which of the following would improve the availability of resources especially for reading in a distributed database system?
    Fragmentation of database
    Replication of database
    Defragmentation of database
    Tuning of database

9. ______________ is very much required to process a query in a distributed database.
    Global System Catalog
    Database Views
    Triggers
    None of the above

10. Reliability and availablity of a Centralized Data Allocation method is ___________ when compared to a Completely Replicated Data Allocation .
    Highest
    Average
    Lowest
    Not applicable

Score =

Correct answers:

Go to Distributed database home

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

data recovery