Database Basics

What is a database?

• A type of computer hardware

• A structured collection of data stored and accessed electronically.

• A collection of physical books

• A software program for editing photos

Explain the difference between a database and a spreadsheet.

• Databases are structured collections of data organized using tables and relationships, while spreadsheets are files with rows and columns for data storage and calculations.

• Databases and spreadsheets are the same thing but with different names.

• Databases are used for text data only, while spreadsheets are used for numerical data only.

• Databases cannot store large amounts of data, unlike spreadsheets.

What is a primary key in a database?

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

• A primary key is a secondary identifier used for sorting records in a table.

• A primary key is a field that can have duplicate values in a table.

• A primary key is a random number assigned to each record in a table.

What is normalization in the context of databases?

• Normalization is the process of deleting data in a database

• Normalization in databases is the process of organizing data in a database efficiently.

• Normalization is the process of encrypting data in a database

• Normalization is the process of merging data in a database

What is SQL and how is it used in databases?

• SQL is only used for storing images in databases

• SQL is a type of programming language used for web development

• SQL is primarily used for creating animations in databases

• SQL is a language used to interact with databases by performing operations like querying, inserting, updating, and deleting data.

What is a foreign key in a database?

• A foreign key in a database is a field that is not related to any other table.

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

• A foreign key in a database is a field that is used for sorting data.

• A foreign key in a database is a field that stores only numeric values.

Describe the concept of data redundancy in databases.

• Data redundancy in databases is the duplication of data within a database system, which can lead to inefficiency, inconsistency, and data integrity problems.

• Data redundancy is the process of compressing data within a database system.

• Data redundancy refers to the encryption of data within a database system.

• Data redundancy is the elimination of data within a database system to improve efficiency.

What are the advantages of using a relational database model?

• Relational databases do not support complex queries

• Relational databases lack data consistency

• Using a relational database model leads to data duplication

• Using a relational database model provides advantages such as structured data storage, data integrity enforcement, support for complex queries, data consistency, data normalization, and scalability/performance optimizations.

What is a query in the context of databases?

• A query in the context of databases is a type of flower

• A query in the context of databases is a type of coffee

• A query in the context of databases is a type of computer mouse

• A query in the context of databases is a request for data or information from a database.

Explain the importance of indexing in databases.

• Indexing in databases slows down query performance

• Indexing in databases is only useful for storing data, not for retrieval

• Indexing in databases is important for enhancing query performance and enabling quick data retrieval.

• Indexing in databases is irrelevant for large datasets