Relational databases and Non-relational databases

What is a relational database?

• A type of database that stores data in tables.

• A type of database that stores data in JSON documents.

• A type of database that stores data in key-value pairs.

• A type of database that stores data in graphs.

What is the term for a data structure in a relational database that contains a set of related attributes?

• Row

• Table

• Tuple

• Index

What is a common use case for a non-relational database?

• Financial transactions

• Social media analytics

• Online transaction processing (OLTP)

• Traditional data warehousing

Which of the following is a type of non-relational database?

• MySQL

• MongoDB

• PostgreSQL

• SQLite

What does SQL stand for?

• Structured Query Language

• Standard Query Language

• Simple Query Language

• Structured Question Language

What type of data structure is typical for non-relational databases?

• Tables

• Graphs

• Key-value pairs

• JSON documents

Which of the following is a primary key in a relational database?

• A unique identifier for each record in a table.

• A key that can have duplicate values.

• A key that is used for sorting data in a table.

• A key that is automatically generated by the database system.

In a relational database, what is a foreign key?

• A key that uniquely identifies each record in a table.

• A key that is used for indexing purposes.

• A key that establishes a link between two tables.

• A key that is used to enforce data integrity constraints.

What is the main difference between relational and non-relational databases?

• The presence or absence of tables.

• Scalability and flexibility in data storage.

• Only one type of data structure

• Performance when dealing with large volumes of data.

Which of the following best describes the CAP theorem in the context of databases?

• Consistency, Availability, Partition tolerance

• Concurrency, Atomicity, Parallelism

• Complexity, Abstraction, Performance

• Compatibility, Adaptability, Portability