O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tick (✓) the Appropriate Answer

1.In which case is the query executed as a single large task?
  1. Parallel processing

  2. Centralised processing

  3. Sequential processing

  4. None of these.

2.What is the value of speed-up if the original system took 200 seconds to perform a task, and two parallel systems took 50 seconds to perform the same task?
  1. 2

  2. 3

  3. 4

  4. None of these.

3.What is the value of scale-up if the original system can process 1000 transactions in a given time, and the parallel system can process 3000 transactions in the same time?
  1. 2

  2. 3

  3. 4

  4. None of these.

4.Which of the following is the expansion of DLM?
  1. Deadlock Limiting Manager

  2. Dynamic Lock Manager

  3. Distributed Lock Manager

  4. None of these.

5.Which of the following is a benefit of a parallel database system?
  1. Improved ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required