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
31. In a shared-memory system, a computer has multiple simultaneously active CPUs that are attached to an interconnection network and can access global main memory and a common array of disk storage.
- TRUE
- FALSE
32. In a shared-memory architecture, a single copy of a multithreaded operating system and multithreaded DBMS can support multiple CPUs.
- TRUE
- FALSE
33. In a shared-memory architecture, memoy access uses a very high-speed mechanism that is easy to partition without losing efficiency.
- TRUE
- FALSE
36. Speed-up is a property in which the time taken for performing a task increases in propertion to the increase in the number of CPUs and disks in parallel.
- TRUE
- FALSE
37. Speed-up enables users to improve the system response time for their queries, assuming the size of their database remain roughtly the same.
- TRUE
- FALSE
38. Scale-up is the ability of handling larger tasks by increasing the degree of pareallelism (providing more resources) in the same time period as the orginal system.
- TRUE
- FALSE
39. Scale-up enables users to increase the sizes off their databases while maintaining roughtly the same response time.
- TRUE
- FALSE