NEW
Font size
WorksheetsParallel & Distributed Database
Total questions: 10
Worksheet time: 5mins
In which case is the query executed as a single large task?
Parallel processing
Centralised processing
Sequential processing
None of these
Which of the following is a benefit of a parallel database system?
Improved performance
Greater flexibility
Better availability
All of these
The architecture having multiple CPUs working in parallel and physically located in a close environment in the same building and communicating at very high speed is called
parallel database system
distributed database system
centralised databases system
None of these
In shared-nothing architecture, each CPU has its own copy of
DBMS
portion of data managed by the DBMS
operating system
All of these
The shared-memory architecture of parallel database system is closest to the
centralised database system
distributed database system
client/server system
None of these
A distributed database system allows applications to access data from
local databases
remote databases
both local and remote databases
None of these
In homogeneous DDBS
there are several sites, each running their own applications on the same DBMS software
all sites have identical DBMS software
all users (or clients) use identical software
All of these
Which of the following is not a benefit of client/server architecture?
Reduction in operating cost
Adaptability
Platform independence
None of these
Data replication is a
technique of breaking up the database into logical units, which may be assigned for storage at the various sites
process of deciding about locating (or placing) data to several sites
technique that permits storage of certain data in more than one site
None of these
Which of the following is the function of a distributed DBMS?
Distributed data recovery
Distributed query processing
Replicated data management
All of these
