NoSQL

What is NoSQL?

• A type of SQL database

• A non-relational database technology that allows for flexible schema design and scalability

• A programming language used to query SQL databases

• None of the above

What are the main types of NoSQL databases?

• Key-Value, Document, Graph, and Relational

• Key-Value, Tabular, Graph, and Document

• Key-Value, Document, Graph, and Object-Oriented

• Relational, Object-Relational, Document-Oriented, and Graph

Which NoSQL database type is best suited for social networking applications?

• Key-Value

• Document

• Graph

• Object-Oriented

Which NoSQL database type is best suited for storing and retrieving JSON documents?

• Key-Value

• Document

• Graph

• Object-Oriented

What is data denormalization, and why is it commonly used in NoSQL databases?

• Combining multiple tables into a single table to reduce join operations

• Splitting a large table into multiple smaller tables

• Converting a relational database into a NoSQL

• Storing redundant data to improve read performance

What is CAP theorem, and what are its implications for NoSQL databases?

• It states that a distributed system can only guarantee two out of three properties: Consistency, Availability, and Partition tolerance

• It proves that a distributed database can always provide strong consistency and availability

• It ensures that a distributed system can handle network partitions without losing data

• It guarantees that a distributed database will always be consistent and partition-tolerant

What is sharding in the context of NoSQL databases?

• The process of splitting a database into multiple smaller databases

• A technique for replicating data across multiple servers

• A method for distributing data evenly across a cluster of machines

• A way to ensure data consistency across multiple data centers

What is a document database?

• A database that stores data in tables with rows and columns

• A database that uses a hierarchical model to organize data

• A database that stores semi-structured data as documents

• A database that models data as objects and their relationships

What is a key-value store?

• A database that stores data as key-value pairs

• A database that uses a hierarchical model to organize data

• A database that stores data in tables with rows and columns

• A database that models data as objects and their relationships

What is a distributed NoSQL database?

• A NoSQL database that is designed to work with distributed file systems

• A NoSQL database that runs on a single, powerful server

• A NoSQL database that is replicated across multiple servers

• A NoSQL database that is partitioned and distributed across a cluster of machines