Distributed Database Handling Quiz 1

What is the primary goal of a distributed database system?

• To simplify database design

• To ensure high latency

• To provide location transparency

• To make data handling more difficult

In distributed database systems, fragmentation refers to:

• Breaking down queries into smaller parts

• Breaking a database into smaller pieces stored at different sites

• Encrypting data for security

• Compressing data to reduce space

Which of the following is a disadvantage of replication in distributed databases?

• Increased data availability

• Faster query response

• Higher storage requirements

• Improved fault tolerance

What does a Distributed Transaction Management system ensure?

• Only fast query processing

• Availability of a single centralized database

• ACID properties across distributed systems

• Fragmentation of all data

In distributed systems, a global query is:

• A query that accesses data from a single site

• A query that updates metadata

• A query involving multiple distributed sites

• A query that deletes remote data

Which of the following is a major factor affecting query processing in a distributed database?

• Query language

• Disk scheduling

• Data location and distribution

• Operating system version

Which of the following is used to determine the best query execution plan?

• Query classifier

• Query optimizer

• Transaction manager

• Replication manager

Which of the following is responsible for converting a high-level query into an algebraic expression in a distributed database system?

• Data Manager

• Query Optimizer

• Query Parser

• Query Processor

Which of the following best describes the data localization phase in distributed query processing?

• Choosing the fastest server

• Translating fragments into local queries

• Encrypting the query

• Distributing the query across all users

In which phase of distributed query processing does fragmentation information play a key role?

• Query parsing

• Data localization

• Transaction scheduling

• Logging