Databases Flashcards
For revising databases
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.
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.