In a(n) __________ database, processing logic for the query is performed on the device that holds each database shard and if necessary, results are consolidated by the DBMS.
A) SQL
B) NoSQL
C) relational
D) OLAP

Question

Quizplus · Accepted Answer

NoSQL databases are designed for distributed environments and can shard data across many nodes. Each node is responsible for processing queries against its own shard, and the results are then consolidated by the database management system. This approach allows for horizontal scaling and high availability. SQL, relational, and OLAP databases may also support sharding, but NoSQL databases are specifically designed for distributed architectures.

In A(n) __________ Database, Processing Logic for the Query Is