ADBMS_Quiz_3_Section_D

Which component of query processing checks if all relation names are valid?

• Translator

• Optimizer

• Parser

• Executor

Which of the following is true about query execution plans?

• Chosen by the user

• Represent final output

• Use only SQL

• Represent sequence of primitive operations

Why are users not expected to write queries with optimization in mind?

• The system is responsible for optimization

• Optimized queries are unreadable

• Users lack expertise

• It makes SQL harder

What benefit does replication provide in distributed databases?

• Reduces disk space

• Increases data availability

• Makes indexing faster

• Avoids need for query optimization

Which of the following improves fault tolerance?

• Centralization

• Caching

• Replication

• Compression

Which of these would most likely require query translation due to schema differences?

• Homogeneous distributed DB

• Cloud DB

• Centralized DB

• Heterogeneous distributed DB

In which scenario is data version consistency easiest to maintain?

• Distributed with fragmentation

• Federated system

• Centralized database

• Peer-to-peer network

A retail company storing different regions’ data on different servers is applying:

• Vertical replication

• Horizontal fragmentation

• Hybrid normalization

• Vertical partitioning

Why is concurrency control more difficult with replication?

• Same data updated at multiple sites

• Joins are expensive

• More tables created

• Many locks needed

Why is fragmentation often preferred over full replication?

• Simpler to implement

• Reduces query speed

• Reduces storage overhead and update cost

• Doesn’t require indexing