Databases Flashcards

For revising databases

You may prefer our related Brainscape-certified flashcards:
1
Q

What is a primary key in a relational database?

A

A primary key is a unique identifier for each record in a database table, ensuring no two records have the same key.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the difference between ACID and BASE properties in databases?

A

ACID properties (Atomicity, Consistency, Isolation, Durability) ensure reliable transactions in relational databases, while BASE (Basically Available, Soft state, Eventual consistency) principles are used in NoSQL databases for scalability and flexibility.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly