ELEVATE SKILLS!
Enquiry FormRSSBRPSCUniversity of RajasthanRTU KotaCareers@SA
ELEVATE SKILLS!

CS Free MCQ Bank

Access a comprehensive computer science MCQ bank for free, featuring hundreds of questions with detailed solutions. Strengthen concepts, practice effectively, and prepare confidently for exams, quizzes, and competitive tests.

  • Home
  • CS MCQs
  • DBMS
  • Suraku Academy | DBMS - Distributed Databases Solved MCQs & PYQs

Q: 1 Which of the following represents the two approaches to store a relation in the distributed database?

  1. Replication and Fragmentation

  2. Biasing and Quorum

  3. Indexing and Partitioning

  4. Propagation and Bullying

[ Option A ]

In a distributed database system, data is stored across multiple sites or nodes, and there are two main approaches to store relations.

  1. Replication.
  2. Fragmentation.

Replication involves storing copies of the same data at multiple sites to increase availability and allow parallel query processing. However, replication requires synchronizing updates across copies to maintain consistency, which adds overhead.
Fragmentation involves dividing a relation into smaller parts called fragments, and storing each fragment at a site where it is most needed.

  • Horizontal Fragmentation: Partitioning by rows, each fragment contains a subset of tuples.
  • Vertical Fragmentation: Partitioning by columns, each fragment contains a subset of attributes plus the key attribute for reconstruction.
     

Thank You for Reading!

Thank you so much for taking the time to read my Computer Science MCQs section carefully. Your support and interest mean a lot, and I truly appreciate you being part of this journey. Stay connected for more insights and updates! If you'd like to explore more tutorials and insights, check out my YouTube channel.

Don’t forget to subscribe and stay connected for future updates.