Parallel Database Systems Questions and Answers

Practice Mode
Showing 10 of 25 questions
Q21
Adding more nodes to increase capacity is called:
  • A Horizontal scaling
  • B Vertical scaling
  • C In-memory scaling
  • D Serial scaling
Answer: Option A
Explanation: Horizontal scaling means adding machines.
Q22
In parallel query processing, granularity refers to:
  • A Query accuracy
  • B Size of tasks
  • C Database errors
  • D Disk space
Answer: Option B
Explanation: Granularity defines how big or small tasks are.
Q23
A skew occurs when:
  • A Data is perfectly balanced
  • B Tasks are equally distributed
  • C Data distribution is uneven
  • D Queries are identical
Answer: Option C
Explanation: Skew slows parallel processing due to imbalance.
Q24
Which is an advantage of parallel databases?
  • A Reduced reliability
  • B Increased query performance
  • C Higher manual work
  • D Limited storage
Answer: Option B
Explanation: Parallel DBs enhance performance by parallel execution.
Q25
Which parallelism type helps overlap operations like scanning and joining?
  • A Task
  • B Pipeline
  • C Data
  • D Row
Answer: Option B
Explanation: Pipeline parallelism overlaps operations in a sequence.

📚 More from Database

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