Free Test Distributed Data Stora... – Databas...

Q1: What is distributed data storage?

A. Storing data across multiple networked sites B. Storing data on a single computer C. Backing up data locally D. Encrypting data

Q2: What is data partitioning?

A. Splitting data into distinct parts for storage B. Encrypting data C. Backing up data D. Data compression

Q3: Which is NOT a common data partitioning method?

A. Hash partitioning B. Range partitioning C. Round-robin partitioning D. Full replication

Q4: What is horizontal partitioning?

A. Different rows stored in different partitions B. Different columns stored separately C. Storing full copies at each site D. Encrypting rows

Q5: What is vertical partitioning?

A. Different columns stored separately B. Different rows stored separately C. Backing up data D. Encrypting columns

Q6: What is replication in distributed storage?

A. Storing copies of data on multiple nodes B. Splitting data C. Encrypting data D. Compressing data

Q7: Which is a challenge in distributed querying?

A. Data consistency B. Writing local queries C. Backing up data D. Encrypting queries

Q8: What is a distributed query?

A. A query accessing data from multiple nodes B. A local query C. A backup operation D. An encryption process

Q9: What does query localization mean?

A. Converting global query into local subqueries B. Encrypting queries C. Backing up queries D. Storing queries

Q10: Which is a technique to improve distributed query performance?

A. Using indexes locally B. Encrypting data C. Backing up data D. Data compression

Q11: What is a global query optimizer?

A. An optimizer that creates execution plans across nodes B. A local query planner C. A backup tool D. Encryption software

Q12: What is data locality?

A. Storing related data close to processing nodes B. Encrypting data C. Backing up data D. Distributing data randomly

Q13: What is a federated database?

A. A system combining multiple autonomous databases B. A single centralized database C. Backup database D. Encrypted database

Q14: Which is an advantage of distributed querying?

A. Parallel query execution B. Slower queries C. More disk usage D. More backups

Q15: What is the role of a query coordinator?

A. Manage query execution across distributed nodes B. Encrypt data C. Store backups D. Parse SQL locally

Q16: What is two-phase commit used for?

A. Ensuring atomicity in distributed transactions B. Compressing data C. Encrypting queries D. Backing up data

Q17: Which of the following is a common data consistency model?

A. Eventual consistency B. Full backup C. Encryption D. Compression

Q18: What is a quorum in distributed querying?

A. Minimum nodes needed to agree on a transaction B. Backup count C. Encryption level D. Compression ratio

Q19: What is sharding?

A. Partitioning data horizontally across nodes B. Encrypting data C. Backing up data D. Compressing data

Q20: Which query type is most challenging in distributed databases?

A. Join queries across nodes B. Local queries C. Backup queries D. Encryption queries

Quiz for Distributed Data Storage and Querying