Databases_Flashcards

Question 1

What makes a good primary key in a database?

Answer 1

A good primary key is unique, not null, stable (unchanging), and minimal.

Question 2

How do we prevent redundant data in a database?

Answer 2

By using normalisation, relational table design, and enforcing foreign key constraints.

Question 3

What is normalisation, and why is it important?

Answer 3

Normalisation is the process of structuring a database to reduce data redundancy and improve data integrity.

Question 4

What does each letter in ACID stand for?

Answer 4

Atomicity, Consistency, Isolation, Durability.

Question 5

Why are ACID properties important?

Answer 5

They ensure reliable processing of database transactions, even in case of errors or failures.

Question 6

How can we write SQL queries to search for specific data in a table?

Answer 6

By using SELECT statements with WHERE clauses, e.g., SELECT name FROM students WHERE grade = ‘A’;