DBMS-Object-Relational Database Questions and Answers
The DBMS Object-Relational Database questions with answers focus on advanced SQL concepts that combine object-oriented features with relational databases. These programming questions and answers are perfect for students preparing for DBMS interviews, SQL certifications, and placements in companies like Infosys, TCS, and IBM. By solving these MCQs, you’ll understand how objects, classes, and inheritance integrate within relational systems. Detailed explanations ensure conceptual clarity for better exam and interview performance.
DBMS-Object-Relational Database
Showing 10 of
62 questions
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.