DBMS-Object-Relational Database
DBMS-Object-Relational Database
51. The shared-memory architecture of parallel database system is closet to the
- centralised database system.
- distributed database system.
- client/server system
- None of these
52. In shared-nothing architecture, each CPU has its own copy of
- DBMS
- portion of data managed by the DBMS
- Operating system
- All of these
53. A global locking system is required in
- shared-disk architecture.
- Shared-nothing architecture
- shared-memory architecture
- None of these.
54. The scalability of shared-disk system is largely determined by the
- capacity of the interconnection network mechanism.
- throughput of the interconnection network mechanism.
- Both (a) and (b)
- None of these
55. Locking is the
- coordination of current tasks.
- method of synchronising current task.
- Both (a) and (b)
- None of these
56. Speed-up is a property in which the time taken for performing a task
- decrease in propertion to the increase in the number of CPUs and disks in parallel
- increase in propertion to the increase in the number of CPUs and disks in parallel.
- Both (a) and (b)
- None of these
57. synchronisation is the
- coordination of current tasks.
- method of synchronising current task.
- Both (a) and (b)
- None of these
58. Parallelism in which the relations are partitioned on multiple disks to reduce the retrieval time of relations from disk is called
- I/O parallelism
- inter-operation parallelism.
- intra-query parallelism.
- inter-query parallelism.
59. In intra-query parallelism
- the execution of a single query is done in parallel on multiple CPUs using shared-nothing parallel architecture technique.
- multiple transactions are executed in parallel, one by each (CPU).
- We parallelise the execution of each individual operation of a task, such as sorting,j projection, join and so on.
- the different operations in a query experssion are executed in parallel.
60. In inter-query parallelism,
- the execution of a single query is done in parallel on multiple CPUs using shared-nothing parallel architecture technique.
- multiple transactions are executed in paralle, one by each (CPU)
- We parallelise the execution of each individual operation of task, such as sorting, projection, join and so on.
- the different operations in a query expresion are executed in parallel.