FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Using Databases

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

In a table, if you need to store the extended price (number of units sold times the price per unit) of an order, you would store the data in a ________ field.

A) text
B) calculated
C) media
D) hyperlink

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

To ensure that there are no duplicate records in a database table, you need to establish a ________.

A) query
B) primary key
C) relationship
D) foreign key

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

A group of related records is called a(n) ________.

A category of information about students, such as their phone numbers, would be stored in a(n) ________.

In terms of databases, a table is also referred to as a(n) ________.

________ fields hold things such as pictures and video clips.

In a database, a text field capable of holding complete paragraphs has a ________ data type.

What is the Access object that organizes data into fields and records?

To combine data from more than one table, you need to create a(n) ________ between the tables.

To establish a relationship between two tables, the primary key in one table is associated with the ________ in the other table.

Most small businesses use ________ databases as they are reliable and less costly.

A(n) ________ is a collection of related data that can be stored, organized, and queried.

Match each of the following terms to its definition: I. field II. relationship III. record IV. table V. primary key A. a group of related fields B. a category of information in a database C. a link between tables that defines how the data is connected D. a field that has a value unique to each record E. a group of related records

A group of related fields is called a ________.

Which of the following is NOT a database component?

The information about a single student would be stored in a ________.

The results of multiplying the Hours field times the Rate field would be stored in a(n) ________ field.

A(n) ________ database stores data in more than two dimensions.