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