DBMS-Object-Relational Database Questions and Answers

Practice Mode
Showing 10 of 62 questions
Q41
In which case is the query executed as a single large task ?
  • A Parallel processing
  • B Centralised processing
  • C Sequential processing
  • D None of these
Answer: Option B
Q42
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 ?
  • A 2
  • B 3
  • C 4
  • D None of these
Answer: Option C
Q43
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 ?
  • A 2
  • B 3
  • C 4
  • D None of these
Answer: Option B
Q44
Which of the following is the expansion DLS ?
  • A Deallock Limiting Manager
  • B Dynamic Lock Manager
  • C Distributed Lock Manager
  • D None of these
Answer: Option C
Q45
Which of the following is a benefit of a parallell database system ?
  • A Improved performance
  • B Greater Flexibility
  • C Better availability
  • D All of these.
Answer: Option D
Q46
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
  • A parallel database system
  • B distributed database system.
  • C centralized database system
  • D None o these
Answer: Option D
Q47
In a shared-memory system, a computer has
  • A 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.
  • B 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.
  • C 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.
  • D None of these
Answer: Option A
Q48
In a shared-memory system, a computer has
  • A 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.
  • B 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.
  • C 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.
  • D None of these
Answer: Option A
Q49
In a shared-disk system, a computer has
  • A 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.
  • B 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.
  • C 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.
  • D None of these
Answer: Option B
Q50
In  a shared-nothing system, a computer has
  • A 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.
  • B 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.
  • C None of these
Answer: Option C

📚 More from Database

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