Introduction to NoSQL Databases

Front

What is a relational database?

Back

A relational database stores data in tables with rows and columns.

Front

What does SQL stand for?

Back

SQL stands for Structured Query Language.

Front

What does ACID stand for in databases?

Back

ACID stands for Atomic, Consistency, Isolation, and Durable.

Front

What is a foreign key?

Back

A foreign key is a column that creates a link between two tables.

Front

Name one property of ACID.

Back

Atomic: All queries in a transaction must complete or none at all.

Front

What is the meaning of consistency in ACID?

Back

Data must be in a valid state according to set conditions.

Front

What does isolation mean in ACID?

Back

Changes made in a transaction cannot be seen until the transaction is complete.

Front

What is durability in ACID?

Back

Committed transactions will remain even if there is a failure.

Front

Name one example of a relational database management system (RDBMS).

Back

Examples include Oracle, Microsoft SQL Server, MySQL, and PostgreSQL.

Front

What is one disadvantage of RDBMS?

Back

RDBMS can be hard to scale horizontally.