DBMS-Object-Relational Database

DBMS-Object-Relational Database
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
Show Answer
32. In a shared-memory architecture, a single copy of a multithreaded operating system and multithreaded DBMS can support multiple CPUs.
  • TRUE
  • FALSE
Show Answer
33. In a shared-memory architecture, memoy access uses a very high-speed mechanism that is easy to partition without losing efficiency.
  • TRUE
  • FALSE
Show Answer
34. Shared-disk architecture is easy to load-balance.
  • TRUE
  • FALSE
Show Answer
35. Shared-nothing architectures are difficult to load-balance.
  • TRUE
  • FALSE
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
39. Scale-up enables users to increase the sizes off their databases while maintaining roughtly the same response time.
  • TRUE
  • FALSE
Show Answer
40. Hash partitioning prevents skewing.
  • TRUE
  • FALSE
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test