ADBMS_Quiz_3_A

The process of finding equivalent query expressions is handled by

• Parser

• Evaluator

• Optimizer

• Translator

Which of the following contributes most to the cost of query evaluation?

• Memory usage

• Disk access

• CPU cycles

• Number of queries

Which approach helps reduce intermediate relation size in query evaluation?

• Performing Filtering early

• Using more joins

• Increasing buffer size

• Delaying projections

What is a risk of using data replication?

• Inconsistency

• Network failure

• Data loss

• Slower queries

Hybrid systems use:

• Centralized logic only

• Replication or fragmentation, not both

• A mix of fragmentation and replication

• Only remote access

In distributed systems, performance improves due to:

• Fewer users

• Scripting Local processing at sites

• High network latency

• More complex queries

In which scenario is vertical fragmentation most useful?

• Archiving old records

• Grouping users by city

• Logging user activity

• Separating sensitive customer info from transaction data

A DBMS that can handle multiple data models and systems is:

• Centralized

• Heterogeneous Distributed

• Homogeneous Distributed

• File-based

In retail, which combination is most common for regional operations and central reporting?

• Fragmentation only

• Combination of replication and fragmentation

• Replication only

• No data distribution

In which scenario is data version consistency easiest to maintain?

• Distributed with fragmentation

• Peer-to-peer network

• Centralized database

• Federated system