Parallel Database Systems Questions and Answers

Practice Mode
Showing 10 of 25 questions
Q11
The term "speedup" in parallel systems means:
  • A Lower accuracy
  • B Faster execution
  • C More failures
  • D Higher costs
Answer: Option B
Explanation: Speedup measures how much faster the system becomes.
Q12
What does “scaleup” measure?
  • A Quality of queries
  • B Ability to handle larger loads
  • C Speed of memory
  • D Data duplication
Answer: Option B
Explanation: Scaleup evaluates handling increased database size/users.
Q13
Which is a common method of data partitioning?
  • A Round-robin
  • B Data hiding
  • C Data cloning
  • D Data masking
Answer: Option A
Explanation: Round-robin distributes rows evenly across nodes.
Q14
Parallel join algorithms are used to:
  • A Delete database
  • B Speed up join operations
  • C Encrypt tables
  • D Merge schemas
Answer: Option B
Explanation: They divide join tasks across processors.
Q15
Pipeline parallelism works by:
  • A Running tasks one after another
  • B Passing intermediate results directly
  • C Restarting queries repeatedly
  • D Storing results permanently
Answer: Option B
Explanation: Pipeline parallelism sends partial outputs to the next stage.
Q16
Which failure affects multiple nodes simultaneously?
  • A Node failure
  • B System failure
  • C Disk failure
  • D User failure
Answer: Option B
Explanation: System failure impacts the entire system.
Q17
Which parallel DB architecture reduces data contention the most?
  • A Shared-memory
  • B Shared-disk
  • C Shared-nothing
  • D Centralized
Answer: Option C
Explanation: Shared-nothing avoids resource sharing, reducing contention.
Q18
What is the first step in query parallelization?
  • A Query rewriting
  • B Query deletion
  • C Query encryption
  • D Query backup
Answer: Option A
Explanation: Rewriting breaks a query into parallelizable parts.
Q19
Replication in a parallel DB helps improve:
  • A Processing speed
  • B Data availability
  • C Program execution
  • D Table deletion
Answer: Option B
Explanation: Replication ensures data remains available if a node fails.
Q20
Which type of parallelism splits data into smaller pieces and processes them independently?
  • A Task
  • B Pipeline
  • C Data
  • D Memory
Answer: Option C
Explanation: Data parallelism divides data so multiple processors work in parallel.

📚 More from Database

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