| CARVIEW |
- Courses
- Tutorials
- Practice
- Jobs
Distributed Databases
Quizzes on Distributed Database
Question 1
What is a Distributed Database System (DDBS)?
A database on a single server
A collection of unrelated databases
A collection of databases at different locations connected by a network
A backup of centralized databases
Question 2
Which type of distributed database uses the same DBMS at all sites?
Homogeneous
Heterogeneous
Peer-to-peer
Client-server
Question 3
Which of the following is not a benefit of distributed databases?
Fault tolerance
Centralized access
Local access
Parallel processing
Question 4
Which model uses a central server with lightweight clients?
Peer-to-peer
Client-server
Cloud-based
Homogeneous
Question 5
What is replication in distributed databases?
Dividing tables into fragments
Linking databases via joins
Copying data to multiple sites
Encrypting data
Question 6
What is fragmentation in DDBMS?
Backing up data
Compressing data
Splitting tables into smaller pieces
Removing redundancy
Question 7
Which control method ensures correct results when multiple transactions occur simultaneously?
Fragmentation
Replication
Semantic control
Concurrency control
Question 8
In horizontal fragmentation, how is a table divided?
By columns
By rows
By schemas
By keys
Question 9
What operation is used to reconstruct data from vertical fragments?
INTERSECT
UNION
DIFFERENCE
JOIN
Question 10
Which replication technique allows multiple replicas to accept updates?
Primary-Backup
Chain
Multi-Primary
Passive
There are 15 questions to complete.
