Parallel and Distributed Databases

What is the advantage of using a parallel database system in a large retail store?

• Increased sales performance

• Enhanced inventory management flexibility

• Improved customer service availability

• All of these

The data center with multiple servers working in parallel and physically located in the same building and communicating at very high speed is called

• parallel database system

• distributed database system

• centralised database system

• None of these

The practice of connecting two or more computing devices together for the purpose of sharing information and resources is known as

• Device connecting 

• Networking

• Networking devices

• Computer network

In shared-nothing architecture, each CPU has its own copy of

• DBMS

• portion of data managed by the DBMS

• operating system

• All of these

In a corporate meeting, what do we call the set of rules that govern the exchange of information over the company's internal network?

• Transmission rules

• Transfer rules

• Channels 

• Protocols

A company's inventory management system allows employees to access data from

• local servers

• cloud servers

• both local and cloud servers

• None of these

In a university setting, Ethan, Olivia, and Avery are all enrolled in the same course.

• Each student is using their own study materials for the course.

• All students are following the same study plan provided by the professor.

• All students are using the same online platform to access course materials.

• All of these

Which of the following is not a benefit of client/server architecture?

• Reduction in operating cost

• Adaptability

• Platform independence

• None of these

Which of the following fragmentation is the original relation is broken into a number of fragments, where each fragment is a subset of rows?

• Flip fragmentation

• Vertical fragmentation

• Horizontal fragmentation

• Linear fragmentation

Importance of distributed and parallel database include all except

• Improve reliability and availability

• Sharing of data

• Faster response time

• Direct access to all disk