DBMS-Object-Relational Database Questions and Answers

Practice Mode
Showing 10 of 62 questions
Q31
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q32
In a shared-memory architecture, a single copy of a multithreaded operating system and multithreaded DBMS can support multiple CPUs.
  • A TRUE
  • B FALSE
Answer: Option A
Q33
In a shared-memory architecture, memoy access uses a very high-speed mechanism that is easy to partition without losing efficiency.
  • A TRUE
  • B FALSE
Answer: Option B
Q34
Shared-disk architecture is easy to load-balance.
  • A TRUE
  • B FALSE
Answer: Option A
Q35
Shared-nothing architectures are difficult to load-balance.
  • A TRUE
  • B FALSE
Answer: Option A
Q36
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q37
Speed-up enables users to improve the system response time for their queries, assuming the size of their database remain roughtly the same.
  • A TRUE
  • B FALSE
Answer: Option A
Q38
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q39
Scale-up enables users to increase the sizes off their databases while maintaining roughtly the same response time.
  • A TRUE
  • B FALSE
Answer: Option A
Q40
Hash partitioning prevents skewing.
  • A TRUE
  • B FALSE
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test