Free Test Distributed Database C... – Databas...

Q1: What is a distributed database?

A. A database distributed across multiple sites B. A single centralized database C. A database on one computer D. A backup database

Q2: Which is a key feature of distributed databases?

A. Data distribution transparency B. Encrypted data C. Single point of failure D. Manual synchronization

Q3: What is fragmentation in distributed databases?

A. Dividing database into smaller parts stored at different sites B. Backing up data C. Encrypting tables D. Copying entire database

Q4: Which type of fragmentation divides data by rows?

A. Horizontal fragmentation B. Vertical fragmentation C. Mixed fragmentation D. No fragmentation

Q5: What is vertical fragmentation?

A. Different columns stored at different sites B. Rows split across sites C. No fragmentation D. Full table replication

Q6: What is replication in distributed databases?

A. Storing copies of data at multiple sites B. Backing up data on tape C. Encrypting data D. Deleting data

Q7: What is the main challenge in distributed databases?

A. Maintaining data consistency across sites B. Writing queries C. Data encryption D. Data compression

Q8: Which protocol is used to maintain atomicity in distributed transactions?

A. TWO-PHASE COMMIT B. Three-way handshake C. Paxos D. RAID

Q9: What is transparency in distributed databases?

A. Hiding distribution details from users B. Encrypting data C. Data backup D. Indexing data

Q10: Which transparency hides the location of data?

A. Location transparency B. Replication transparency C. Transaction transparency D. Performance transparency

Q11: What is a distributed transaction?

A. A transaction that accesses data at multiple sites B. A transaction on one site C. A local backup D. A query plan

Q12: What is fragmentation transparency?

A. Hiding fragmentation details from users B. Encrypting data C. Backing up data D. Data compression

Q13: Which is NOT a type of distributed database transparency?

A. Encryption transparency B. Location transparency C. Replication transparency D. Fragmentation transparency

Q14: What does heterogeneity mean in distributed databases?

A. Differences in hardware, software, and data models B. Identical systems C. Data encryption D. Data replication

Q15: What is data autonomy?

A. Sites control their local data independently B. Data is fully controlled centrally C. Data is encrypted D. Data backup

Q16: Which is a benefit of distributed databases?

A. Improved reliability and availability B. Slower queries C. Data loss D. More backup required

Q17: Which is a disadvantage of distributed databases?

A. Complexity of management and synchronization B. Simple design C. Single point of failure D. No need for backup

Q18: What is a global catalog in distributed DB?

A. A directory of data locations and metadata B. Backup files C. Encryption keys D. Transaction logs

Q19: Which method is used to ensure consistency in distributed DB?

A. Two-phase commit protocol B. Full table scans C. Data compression D. Encryption

Q20: What is replication transparency?

A. Hiding replication from users B. Encrypting data C. Backing up data D. Data compression

Quiz for Distributed Database Concepts