Databases

Question 1

What is a database?

Answer 1

A database is an organized collection of data.

Question 2

What is SQL?

Answer 2

SQL stands for Structured Query Language, which is used for managing and manipulating relational databases.

Question 3

What is a primary key?

Answer 3

A primary key is a unique identifier for each record in a database table.

Question 4

What is normalization in databases?

Answer 4

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

Question 5

What is a foreign key?

Answer 5

A foreign key is a field in a database table that links to the primary key in another table.

Question 6

What is a relational database?

Answer 6

A relational database is a type of database that stores data in tables and establishes relationships between them.

Question 7

What is ACID in database transactions?

Answer 7

ACID stands for Atomicity, Consistency, Isolation, and Durability, which are properties that guarantee database transactions are processed reliably.

Question 8

What is a database index?

Answer 8

A database index is a data structure that improves the speed of data retrieval operations on a database table.

Question 9

What is a composite key?

Answer 9

A composite key is a combination of two or more columns that uniquely identifies a record in a database table.