DBMS-Object-Relational Database
DBMS-Object-Relational Database
41. In which case is the query executed as a single large task ?
- Parallel processing
- Centralised processing
- Sequential processing
- None of these
42. 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 ?
- 2
- 3
- 4
- None of these
43. 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 ?
- 2
- 3
- 4
- None of these
44. Which of the following is the expansion DLS ?
- Deallock Limiting Manager
- Dynamic Lock Manager
- Distributed Lock Manager
- None of these
45. Which of the following is a benefit of a parallell database system ?
- Improved performance
- Greater Flexibility
- Better availability
- All of these.
46. 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.
- centralized database system
- None o these
47. In a shared-memory system, a computer has
- seveal simultaneously active CPUs that are attached to an interconnection network and can share a single main memory and a common array of disk storage.
- multiple CPUs attached to an interconnection network and each CPU has their own memory but all of them have access to the same disk storage or to a shared array of disks.
- multiple CPUs attached to an interconnection network through a node an each CPU has a local memory and disk storage, but no two CPUs can access the same disk storage area.
- None of these
48. In a shared-memory system, a computer has
- seveal simultaneously active CPUs that are attached to an interconnection network and can share a single main memory and a common array of disk storage.
- multiple CPUs attached to an interconnection network and each CPU has their own memory but all of them have access to the same disk storage or to a shared array of disks.
- multiple CPUs attached to an interconnection network through a node an each CPU has a local memory and disk storage, but no two CPUs can access the same disk storage area.
- None of these
49. In a shared-disk system, a computer has
- several simultaneously active CPUs that are attached to an interconnection network and can share a single main memory and a common array of disk storage.
- multiple CPUs attached to an interconnection network and each CPU has their own memory but all of them have access to the same disk storage or to a shared array of disks.
- multiple CPUs attched 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.
- None of these
50. In a shared-nothing system, a computer has
- several simultaneously active CPUs that are attached to an interconnection network and can share a single main memory and a common array of disk storage.
- multiple CPUs 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.
- None of these