Database Concepts Flashcard 2

Front

What is a primary key in a student database?

Back

A field that uniquely identifies a record.

Answer explanation

A primary key is a field that uniquely identifies a record in a database, ensuring that no two records have the same value in that field. This is essential for maintaining data integrity.

Front

Paul is organizing a database for his travel agency. Which of the following is an example of a primary key he might use to uniquely identify each client's record? Passport number, Country name, Address, Phone number

Back

Passport number

Answer explanation

A primary key uniquely identifies a record in a database. A passport number is unique to each individual, making it a suitable primary key. In contrast, country names, addresses, and phone numbers can be duplicated.

Front

What is the purpose of a query in a library database?

Back

To ask questions and retrieve specific information from a table.

Answer explanation

The purpose of a query in a database is to ask questions and retrieve specific information from a table. This allows users to access and manipulate data effectively, unlike the other options which serve different functions.

Front

Jahmar is designing a database for his school project. Which view should he use to create a primary key?

Back

Design View

Answer explanation

The Design View is used to define the structure of a database table, including setting a primary key. In contrast, Datasheet, Print, and Query Views are for data entry, presentation, and querying, respectively.

Front

What is the difference between a file and a folder?

Back

A folder contains files, while a file stores specific data.

Answer explanation

A folder is a container that holds multiple files, while a file is a single unit that stores specific data. Therefore, the correct choice is that a folder contains files, while a file stores specific data.

Front

Elairda is designing a database for her school project. Which rule applies when creating a primary key?

Back

It cannot contain duplicates.

Answer explanation

A primary key must be unique for each record in a table, meaning it cannot contain duplicates. This ensures that each entry can be distinctly identified. The other options do not accurately describe primary key requirements.

Front

Which term refers to a single piece of data in a table storing song's title, artist, and album information? Options: Field, Record, Query, File

Back

Field

Answer explanation

In a table, a 'Field' refers to a single piece of data, such as a name or age. Each field holds specific information about a record, making 'Field' the correct term for a single data element.

Front

In a classroom database, which field uniquely identifies each student record?

Back

Primary key

Answer explanation

The primary key is a field that uniquely identifies each record in a table, ensuring that no two records have the same value in this field. This is essential for maintaining data integrity and enabling efficient data retrieval.

Front

Dornel is managing a student database and tries to assign duplicate student ID numbers to a primary key. What happens?

Back

The database will generate an error message.

Answer explanation

A primary key must contain unique values. If you try to assign duplicate values, the database will generate an error message, preventing the operation to maintain data integrity.

Front

In the context of a database, what would each song represent?

Back

A collection of related data fields.

Answer explanation

A "record" in a database refers to a collection of related data fields, which together represent a single entry in a table. This distinguishes it from a column, duplicates, or a backup.