Database and PowerPoint Quiz

In a relational database, which component is used to link tables together?

• Primary Key

• Foreign Key

• Table Index

• Search Query

Which of the following best describes a primary key?

• A unique identifier for each record in a table

• A field that links two tables

• A randomly generated number for security

• A field used to store passwords

What is a foreign key in a database?

• A key that allows access to a restricted database

• A field in a table that refers to the primary key in another table

• A key that encrypts data in a table

• A duplicate entry in a database

One of the following is a disadvantage of a flat file database?

• It eliminates redundancy

• It requires complex queries to retrieve data

• It causes data redundancy and inefficient storage

• It is easier to maintain than relational databases

A flat file database is one that

• stores all data in a single table

• organizes data into multiple tables

• is optimized for graphics and images

• specifies cloud-based data storage system

What is a database report used for?

• To store raw data

• To present information from a database in a structured format

• To remove duplicate records

• To edit table structures

What does a query do in a database?

• Modifies data in the database permanently

• Searches for and retrieves specific data

• Deletes all data in a table

• Formats the database for printing

In a relational database, which key is used to uniquely identify each record?

• Foreign key

• Primary key

• Secondary key

• Sorting key

What is the purpose of validation checks in a database?

• To ensure data entered is accurate and meets certain criteria

• To correct spelling mistakes in database entries

• To encrypt data for security reasons

• To compare two datasets for similarities

Which of the following is a type of database?

• Spreadsheet

• Flat file

• Operating system

• Web browser