NoSQL Databases Quiz

What is a NoSQL database?

• A relational database using SQL

• A non-relational database for unstructured data

• A database only for structured data

• A database that requires ACID properties

Which of the following is a popular NoSQL database?

• MySQL

• Oracle

• MongoDB

• PostgreSQL

Do NoSQL databases always adhere to ACID properties?

• Yes, they strictly adhere to ACID

• No, they prioritize availability and partition tolerance

• Yes, they provide immediate consistency

• No, they do not support any consistency

How is data structured in a document-based NoSQL database like MongoDB?

• Tables and rows

• JSON-like documents

• Key-value pairs

• Nodes and relationships

Can a relational database be used as a NoSQL database?

• Yes, directly without any modifications.

• No, relational databases cannot mimic NoSQL behavior.

• Not directly, but some relational databases offer features that mimic NoSQL behavior.

• Only if the database is converted to NoSQL.

What does a LEFT OUTER JOIN return?

• Only matching rows from both tables.

• All rows from the left table and matching rows from the right.

• All rows from the right table and matching rows from the left.

• Only non-matching rows from both tables.

What is the result of a FULL OUTER JOIN?

• Only matching rows from both tables.

• All rows from the left table only.

• All rows from the right table only.

• All records with NULLs where there's no match.

How does a NATURAL JOIN work?

• Joins tables based on columns with different names.

• Joins tables based on columns with the same name.

• Joins tables without any conditions.

• Joins tables using a specified key.

What is a key-value pair?

• A data structure where each value is associated with multiple keys.

• A data structure where each key is associated with a value.

• A data structure with no unique identifiers.

• A data structure that only stores keys.

What is a key-value data type in Python?

• list

• dict

• tuple

• set