NO SQL DATA MANAGEMENT

What is SQL used for?

• A scripting language used for front end development

• A programming language that is typically used in relational database or data stream management systems

• A middleware used to connect to relational databases.

Answer explanation

SQL, or Structured Query Language, is primarily a programming language used for managing and manipulating relational databases and data streams, making the second choice the correct answer.

What is meant by NoSQL?

• It means I don't want to do SQL

• A reference to Oracle relational database structure

• Not only SQL, a different approach than traditional relational databases.

Answer explanation

NoSQL stands for 'Not only SQL', indicating a database approach that differs from traditional relational databases. It encompasses various data models, including document, key-value, and graph databases, allowing for more flexibility.

What is MongoDB?

• A NoSQL document orient database

• A database that uses graph structures for semantic queries

• A relational database that uses table structure

Answer explanation

MongoDB is a NoSQL document-oriented database, meaning it stores data in flexible, JSON-like documents rather than in fixed tables. This allows for more dynamic data structures compared to traditional relational databases.

MongoDB has a database schema?

• True

• False

Answer explanation

MongoDB is a NoSQL database that does not require a fixed schema. It allows for flexible data models, meaning documents can have different structures, making the statement false.

What is the primary advantage of using NoSQL databases?

• They require less memory than traditional databases

• They are always faster than SQL databases

• They can handle large volumes of unstructured data

Answer explanation

The primary advantage of NoSQL databases is their ability to handle large volumes of unstructured data, making them ideal for applications that require flexibility and scalability in data storage.

Which of the following is a characteristic of MongoDB?

• It uses a fixed schema

• It stores data in JSON-like documents

• It is primarily used for relational data

Answer explanation

MongoDB is a NoSQL database that stores data in flexible, JSON-like documents, allowing for dynamic schemas. This characteristic enables easier data modeling compared to traditional fixed-schema databases.

What does the term 'schema-less' mean in the context of NoSQL databases?

• Data is always encrypted

• Data can be stored without any structure

• Data must follow a strict format

Answer explanation

The term 'schema-less' in NoSQL databases means that data can be stored without any predefined structure, allowing for flexibility in how data is organized. This contrasts with traditional databases that require a strict format.

What type of data model does Cassandra use?

• Key-value store

• Wide-column store

• Document store

Answer explanation

Cassandra uses a wide-column store data model, which allows for flexible and scalable storage of data in rows and columns, making it suitable for handling large amounts of data across distributed systems.

Which of the following is a benefit of using a NoSQL database?

• Supports complex joins

• Scalability across distributed systems

• Enforces strict data integrity

Answer explanation

A key benefit of NoSQL databases is their scalability across distributed systems, allowing them to handle large volumes of data and traffic efficiently. In contrast, they do not support complex joins or enforce strict data integrity like traditional SQL databases.

What is the primary purpose of a database index?

• To store data in a compressed format

• To speed up data retrieval operations

• To ensure data is always backed up

Answer explanation

The primary purpose of a database index is to speed up data retrieval operations. By creating an index, the database can quickly locate and access the data without scanning the entire table, improving performance.