Sunday, November 21, 2010

Chapter 10 CC

1.

A database contains files, a file contains ____.

A) characters, a character contains fields, and a field is made up of records
B) fields, a field contains characters, and a character is made up of records
C) records, a record contains characters, and a character is made up of fields
D) records, a record contains fields, and a field is made up of characters

Points Earned:

1.0/1.0


Correct Answer(s):

D

2.

A ____ is the smallest unit of data a computer can process.

A) bit
B) character
C) field
D) record

Points Earned:

1.0/1.0


Correct Answer(s):

A

3.

____ is a common data type that consists of dollar and cent amounts or numbers containing decimal values.

A) AutoNumber
B) Text
C) Currency
D) Object

Points Earned:

1.0/1.0


Correct Answer(s):

C

4.

Generally, users change records in a file ____.

A) when they obtain new data and to correct inaccurate data
B) to correct inaccurate data and to update old data with new data
C) to update old data with new data and when a record no longer is needed
D) when a record no longer is needed and when they obtain new data

Points Earned:

0.0/1.0


Correct Answer(s):

B

5.

A(n) ____ verifies that a required field contains data.

A) range check
B) completeness check
C) consistency check
D) alphabetic/numeric check

Points Earned:

0.0/1.0


Correct Answer(s):

B

6.

A major weakness of a lot of file processing systems is that ____.

A) they have redundant data and they isolate data
B) they are much more complex than a database
C) data is more vulnerable than data in a database
D) all of the above

Points Earned:

0.0/1.0


Correct Answer(s):

A

7.

Popular data models in use today include all of the following except ____.

A) relational
B) hierarchical
C) object-oriented
D) multidimensional

Points Earned:

0.0/1.0


Correct Answer(s):

B

8.

In a relational database, each row ____.

A) and each column has a primary key
B) has a unique name and each column has a primary key
C) has a primary key and each column has a unique name
D) and each column has a unique name

Points Earned:

1.0/1.0


Correct Answer(s):

C

9.

A user of a relational database, refers to a record as a ____.

A) table
B) column
C) row
D) relationship

Points Earned:

0.0/1.0


Correct Answer(s):

C

10.

____, is a query language that allows users to manage, update, and retrieve data.

A) XML
B) DBMS
C) SQL
D) QBE

Points Earned:

1.0/1.0


Correct Answer(s):

C

No comments:

Post a Comment