Data fragmentation, replication, and allocation in DBMS

By: Prof. Dr. Fazal Rehman Shamil | Last updated: September 23, 2024

1. What is data fragmentation in a distributed database system?
   a) Dividing data into multiple copies
   b) Breaking data into pieces and storing them at different locations
   c) Encrypting data for security
   d) Combining data from multiple sourcesAnswer: b) Breaking data into pieces and storing them at different locations
2. Which type of data fragmentation involves dividing a table into multiple parts, with each part containing a subset of the rows (records)?
   a) Vertical Fragmentation
   b) Horizontal Fragmentation
   c) Mixed Fragmentation
   d) ReplicationAnswer: b) Horizontal Fragmentation
3. What is vertical fragmentation in a distributed database system?
   a) Storing different rows of a table at different locations
   b) Dividing a table into columns and storing each column at different locations
   c) Creating multiple copies of the entire table
   d) Storing data in multiple formatsAnswer: b) Dividing a table into columns and storing each column at different locations
4. In data replication, what is the main objective?
   a) To improve data consistency across nodes
   b) To increase data availability and fault tolerance
   c) To reduce data redundancy
   d) To optimize data retrieval speedAnswer: b) To increase data availability and fault tolerance
5. What is the difference between full replication and partial replication?
   a) Full replication involves replicating the entire database at every node, while partial replication involves replicating only a subset of data
   b) Full replication is faster than partial replication
   c) Partial replication involves storing multiple copies of data at one node
   d) Full replication requires less storage space than partial replicationAnswer: a) Full replication involves replicating the entire database at every node, while partial replication involves replicating only a subset of data
6. Which type of data allocation strategy involves storing data at the location closest to where it is most frequently accessed?
   a) Centralized Allocation
   b) Local Allocation
   c) Global Allocation
   d) Partitioned AllocationAnswer: b) Local Allocation
7. In the context of distributed databases, what is ‘data allocation’?
   a) The process of replicating data across multiple nodes
   b) The strategy for storing data fragments in different locations based on access patterns
   c) The encryption of data for secure transmission
   d) The backup of data to prevent lossAnswer: b) The strategy for storing data fragments in different locations based on access patterns
8. Which of the following techniques is used to maintain consistency in a distributed database system where data is replicated across multiple nodes?
   a) Two-Phase Commit Protocol
   b) Vertical Fragmentation
   c) Data Encryption
   d) Data ShardingAnswer: a) Two-Phase Commit Protocol
9. In data fragmentation, what does ‘mixed fragmentation’ refer to?
   a) Combining horizontal and vertical fragmentation techniques
   b) Encrypting data before fragmentation
   c) Fragmenting data into multiple copies
   d) Using multiple databases to store the same dataAnswer: a) Combining horizontal and vertical fragmentation techniques
10. What is the primary benefit of data fragmentation in a distributed database system?
    a) Increased data security
    b) Improved data retrieval performance by reducing data access times
    c) Simplified database design
    d) Reduced need for backup and recoveryAnswer: b) Improved data retrieval performance by reducing data access times
11. Which of the following is a key challenge associated with data replication in distributed databases?
    a) Data consistency and synchronization across multiple nodes
    b) Decreased data redundancy
    c) Centralized control of data
    d) Reduced data access speedAnswer: a) Data consistency and synchronization across multiple nodes
12. What does ‘partial replication’ refer to in the context of distributed databases?
    a) Replicating the entire database at multiple sites
    b) Replicating only a subset of data or tables across multiple sites
    c) Combining data from multiple databases into one
    d) Storing data in a centralized locationAnswer: b) Replicating only a subset of data or tables across multiple sites
13. Which of the following describes the ‘centralized allocation’ of data in a distributed database system?
    a) Storing all data at a single central location
    b) Distributing data fragments across multiple locations
    c) Replicating data across all nodes
    d) Storing data based on access patternsAnswer: a) Storing all data at a single central location
14. What is the role of ‘metadata’ in managing data fragmentation and replication?
    a) To define the structure and location of data fragments and replicas
    b) To encrypt data for secure storage
    c) To handle user authentication and authorization
    d) To perform data backup and recoveryAnswer: a) To define the structure and location of data fragments and replicas
15. Which data allocation strategy involves distributing data based on the frequency of access to minimize network traffic?
    a) Random Allocation
    b) Proportional Allocation
    c) Local Allocation
    d) Centralized AllocationAnswer: c) Local Allocation

More MCQs Of Database Systems

1. Database Models MCQs in DBMS
   1. Hierarchical model MCQs in DBMS
   2. Network model MCQs in DBMS
   3. Relational model MCQs in DBMS
   4. Object-oriented model MCQs in DBMS
   5. NoSQL databases MCQs in DBMS
2. Relational Database Model MCQs in DBMS
   1. tables, attributes, tuples, and relations MCQs in DBMS
   2. Primary keys and foreign keys MCQs in DBMS
   3. Integrity constraints MCQs in DBMS
3. SQL (Structured Query Language) MCQs in DBMS
   1. Data Definition Language (DDL) MCQs in DBMS
   2. Data Manipulation Language (DML) MCQs in DBMS
   3. Data Control Language (DCL) MCQs in DBMS
   4. Transaction Control Language (TCL) MCQs in DBMS
   5. Advanced SQL queries and functions MCQs in DBMS
4. Database Design MCQs in DBMS
   1. Entity-Relationship (ER) modeling MCQs in DBMS
   2. Extended ER modeling MCQs in DBMS
   3. Normalization and normal forms (1NF, 2NF, 3NF, BCNF) MCQs in DBMS
   4. Denormalization MCQs in DBMS
5. Database Management System Architecture MCQs in DBMS
   1. Three-schema architecture (external, conceptual, internal) MCQs in DBMS
   2. Data independence MCQs in DBMS
   3. DBMS components and functions MCQs in DBMS
6. Storage and File Structure MCQs in DBMS
   1. Data storage on physical media MCQs in DBMS
   2. File organization and access methods MCQs
   3. Indexing (B-trees, hash indexing) MCQs in DBMS
   4. RAID technology MCQs in DBMS
7. Query Processing and Optimization MCQs in DBMS
8. Database Transaction Management MCQs in DBMS
   1. ACID properties (Atomicity, Consistency, Isolation, Durability) MCQs in DBMS
   2. Transaction states and lifecycle MCQs in DBMS
   3. Concurrency control techniques (locking, timestamping, multiversion) MCQs in DBMS
   4. Deadlock detection and resolution MCQs in DBMS
9. Database Security and Authorization MCQs in DBMS
   1. Authentication and authorization mechanisms MCQs in DBMS
   2. Data encryption techniques MCQs in DBMS
   3. Role-based access control MCQs in DBMS
   4. SQL injection prevention MCQs in DBMS
10. Backup and Recovery MCQs in DBMS
    1. Backup types and strategies MCQs in DBMS
    2. Recovery techniques (log-based, shadow paging) MCQs in DBMS
    3. Disaster recovery planning MCQs in DBMS
11. Distributed Databases MCQs in DBMS
    1. Distributed database architecture MCQs MCQs in DBMS
    2. Data fragmentation, replication, and allocation in DBMS
    3. Distributed query processing MCQs in DBMS
    4. Consistency models and protocols MCQs in DBMS

1. SET 1: database design mcqs (database design mcqs )
2. SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
3. SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
4. SET 4: database systems mcqs (database systems mcqs)
5. SET 5: dbms mcqs (dbms mcqs )
6. SET 6: dbms mcqs with answers (dbms mcqs with answers)
7. SET 7: solved mcqs of dbms (solved mcqs of dbms)
8. SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
9. SET 9: relational database management system mcqs(relational database management system mcqs)
10. SET 10: solved mcqs of database management system(solved mcqs of database management system)
11. SET 11: basic database mcqs pdf (basic database mcqs pdf)
12. SET 12: relational database management system mcqs (relational database management system mcqs )
13. SET 13: database mcqs online test (database mcqs online test)
14. SET 14: database interview questions mcqs (database interview questions mcqs)
15. SET 15: database developer mcqs (database developer mcqs)
16. SET 16: database Repeated mcqs (database Repeated mcqs)
17. SET 17: Database mcqs PPSC (Database mcqs PPSC)
18. SET 18: Database mcqs FPSC (Database mcqs FPSC)
19. SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)

New Arrival