Understanding Databases

What is a database?

• A database is a type of software used for web development.

• A database is a programming language for data manipulation.

• A database is an organized collection of structured data stored electronically.

• A database is a physical storage device for files.

What are the different types of databases?

• Object-oriented

• Graph

• Relational, NoSQL, In-memory, Time-series

• Flat-file

Explain the concept of normalization in databases.

• Normalization is the process of combining all data into a single table.

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

• Normalization increases data redundancy to enhance performance.

• Normalization is a method for encrypting sensitive data in databases.

What is SQL and its purpose in database management?

• SQL is primarily used for graphic design.

• SQL is a programming language used for managing and manipulating relational databases.

• SQL is a type of spreadsheet software.

• SQL is a markup language for web development.

What is the difference between primary key and foreign key?

• A primary key can be null; a foreign key cannot be null.

• A primary key is used for indexing; a foreign key is used for sorting.

• A primary key uniquely identifies records; a foreign key links records between tables.

• A primary key is always a string; a foreign key is always an integer.