Comptia ITF Lesson 9 Databases

What is a database?

• A database is a random collection of data.

• A database is a type of computer hardware.

• A database is a structured collection of data.

• A database is a software program used for creating spreadsheets.

What are the advantages of using databases?

• Data inconsistency, data corruption, data exposure, slow data retrieval and storage, limited scalability, and single-user access.

• Data consistency, data integrity, data security, efficient data retrieval and storage, scalability, and concurrent access.

• Data redundancy, data loss, data exposure, slow data retrieval and storage, limited scalability, and single-user access.

• Data inconsistency, data corruption, data vulnerability, slow data retrieval and storage, limited scalability, and single-user access.

What is a table in a database?

• A table in a database is a collection of unrelated data organized in rows and columns.

• A table in a database is a collection of files and folders.

• A table in a database is a collection of functions and procedures.

• A table in a database is a collection of related data organized in rows and columns.

What is a record in a database?

• A record in a database is a single data field.

• A record in a database is a backup of the entire database.

• A record in a database is a type of database management system.

• A record in a database is a collection of related data fields that are organized and stored together.

What is a field in a database?

• A field in a database is a software program used to manage data.

• A field in a database is a specific piece of information that is stored in a database table.

• A field in a database is a query used to retrieve information.

• A field in a database is a type of data structure.

What is a primary key in a database?

• A primary key in a database is a field that can be duplicated in multiple records.

• A primary key in a database is a field that stores the most important data.

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

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

What is a foreign key in a database?

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

• A foreign key in a database is a field or a set of fields in a table that refers to the primary key of another table.

• A foreign key in a database is a field that is used to uniquely identify a record in a table.

• A foreign key in a database is a field that is used to sort the records in a table.

What is a query in a database?

• A query in a database is a command to delete all data from a database.

• A query in a database is a function that calculates the average of all values in a database.

• A query in a database is a statement that adds a new table to a database.

• A query in a database is a request for information from a database.

What is normalization in database design?

• The process of organizing data in a database to increase redundancy and decrease data integrity.

• The process of organizing data in a database to eliminate redundancy and improve data integrity.

• The process of randomly arranging data in a database to improve data redundancy.

• The process of adding redundancy to data in a database to improve data integrity.

What is denormalization in database design?

• The process of removing redundant data to improve performance of read operations.

• The process of adding more tables to improve performance of read operations.

• The process of normalizing data to improve performance of read operations.

• The process of adding redundant data to improve performance of read operations.