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
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