Database Concepts Quiz 2

Jazari is designing a student database for his school project. What is a primary key in this database?

• A field that uniquely identifies a record.

• A duplicate field in a table.

• A field used for calculations.

• A field that stores only text values.

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.

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

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.

Juvante is managing a library database. What is the purpose of a query in this database?

• To delete records permanently.

• To ask questions and retrieve specific information from a table.

• To create new tables automatically.

• To back up the database.

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.

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

• Design View

• Datasheet View

• Print View

• Query 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.

Kemar is organizing his computer. What is the difference between a file and a folder?

• A file contains other files, while a folder stores data.

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

• A file is larger than a folder.

• A folder is always smaller than a file.

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.

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

• It cannot contain duplicates.

• It must always store numbers.

• It can be empty or null.

• It should be the last column in the table.

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.

Javell is organizing his music collection on his computer. Each song's title, artist, and album information is stored in a table. Which term refers to a single piece of data in this table?

• Field

• Record

• Query

• File

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.

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

• Primary key

• Foreign key

• Duplicate key

• Search 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.

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

• The database system will accept the duplicates.

• The database will generate an error message.

• The duplicate values will be ignored.

• The duplicates will overwrite the existing values.

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.

Rasheed is organizing his music collection on his computer. Each song has information like title, artist, album, and duration. In the context of a database, what would each song represent?

• A collection of related data fields.

• A single column in a table.

• A set of duplicate entries.

• A backup of the database.

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.