DBMS-Object-Relational Database

DBMS-Object-Relational Database
21. Synchronisation is necessary for correctness.
  • TRUE
  • FALSE
Show Answer
22. The key to successful parallel jprocessing is to divide up tasks so that very little synchronisation is necessary.
  • TRUE
  • FALSE
Show Answer
23. The more is the synchronisation, better is the speed-up and scale-up.
  • TRUE
  • FALSE
Show Answer
24. With good speed-up, if transction volumes grow, response time can be kept constant by adding hardware resources such as CPUs.
  • TRUE
  • FALSE
Show Answer
25. Parallel database systems can make it possible to overcome the limitations, enabling a single system no serve thousands of users.
  • TRUE
  • FALSE
Show Answer
26. 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.
  • TRUE
  • FALSE
Show Answer
27. Parallel processing divides a large task into many smaller tasks and executes the smaller tasks concurrently on several  nodes (CPUs)
  • TRUE
  • FALSE
Show Answer
28. 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
  • TRUE
  • FALSE
Show Answer
29. 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.
  • TRUE
  • FALSE
Show Answer
30. 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.
  • TRUE
  • FALSE
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test