Databases Flashcards
1
Q
When would you use a relational database?
A
Relational databases are good for use cases where there’s a high emphasis on transactions and you have structured, orderly data.
2
Q
What are the benefits and tradeoffs of using a NoSQL database?
A
NoSQL databases are designed for performance and scalability at the cost of consistency or availability.
3
Q
What is the CAP theorem?
A
CAP theorem is the idea that a distributed data store cannot simultaneously be consistent, available, and partition tolerant. In reality, you want your system to be strongly consistent or highly available under a network partition.
4
Q
What is eventual consistency?
A
The idea that given no recent updates, your database servers will return the same data.
