DBMS-Object-Relational Database Questions and Answers
Practice ModeShowing 10 of 62 questions
Q21
Synchronisation is necessary for correctness.
Answer: Option A
Q22
The key to successful parallel jprocessing is to divide up tasks so that very little synchronisation is necessary.
Answer: Option A
Q23
The more is the synchronisation, better is the speed-up and scale-up.
Answer: Option B
Q24
With good speed-up, if transction volumes grow, response time can be kept constant by adding hardware resources such as CPUs.
Answer: Option A
Q25
Parallel database systems can make it possible to overcome the limitations, enabling a single system no serve thousands of users.
Answer: Option A
Q26
In a parallel database system, muliple CPUs are working in parallel and are physically located in a close environment in the same building and communicating at a very high speed.
Answer: Option A
Q27
Parallel processing divides a large task into many smaller tasks and executes the smaller tasks concurrently on several nodes (CPUs)
Answer: Option A
Q28
The goal of parallel database systems is usually to ensure that the database system can continue to perform at an acceptable speed, even as the size of the database and the number of transactions increases
Answer: Option A
Q29
In a shared-disk system, multiple CPUs are attached to an interconnection network through a node and each CPU has a local memory and disk storage, but no two CPUs can access the same disk storage area.
Answer: Option B
Q30
In a shared-nothing system, multiple CPUs are attached to an interconnection network and each CPU has their own memory but all of them have access to the same disk storage or, more commonly, to a shared array of disks.
Answer: Option B