(CIS 100) Testbank Questions: Using Databases over (Chapter 11)

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

1.) Relational Database 2.)Related data 3.

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

1.) deletion rule 2.)type the criterion statement 3.)

Table

1.A category of information in a database. 2.A field that has a value unique to each record. 3.

Record

1.A field that has a value unique to each record. 2. A link between tables that defines how the data is connected. 3.

Relationship

1.A group of related fields. 2. A group of related records. 3.

Field

1.A group of related records. 2. A group of related fields. 3.

Primary Key

1.A link between tables that defines how the data is connected. 2. A category of information in a database. 3.

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.

Calculated

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

Field

Which of the following is NOT a database component?

List

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

Long Text

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

Multidimensional

________ fields hold things such as pictures and video clips .

OLE Object

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

Primary key

A group of related fields is called a _____ .

Record

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

Records

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

Relational

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

Relationship

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

Table

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

Table

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

calculated

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

database