MIS 505 Final Exam Review 3 Chapter 8: Advanced Data Handling Concepts
TRUE/FALSE
1. The sorting process is usually reserved for a relatively large number of data items.
ANS: F PTS: 1 REF: 326
2. In every popular computer coding scheme, “A” is numerically one greater than “B.”
ANS: F PTS: 1 REF: 326
3. You do not need to determine a record’s exact physical address in order to use it.
ANS: T PTS: 1 REF: 353
4. When a record is removed from an indexed file, it has to be physically removed.
ANS: F PTS: 1 REF: 354
5. Every time you add a new record to a linked list, you search through the list for the correct logical
location of the new record.
ANS: T PTS: 1 REF: 354
MULTIPLE CHOICE
1. When records are in ____ order, they are arranged one after another on the basis of the value in a
particular field.
a. random c. some
b. sequential d. incremental
ANS: B PTS: 1 REF: 326
2. The ____ is used as a statistic in many cases because it represents a more typical case.
a. mode c. average
b. mean d. median
ANS: D PTS: 1 REF: 326
3. The ____ is skewed by a few very high or low values.
a. mode c. mean
b. median d. standard deviation
ANS: C PTS: 1 REF: 326
4. When you store data records, they exist in ____.
a. some type of order
b. the reverse order from how they were entered
c. the same default ordering for all systems
d. a random order
ANS: A PTS: 1 REF: 326
, 5. When you create a ____ report, the records must have been sorted in order by a key field.
a. summary c. detail
b. control break d. control option
ANS: B PTS: 1 REF: 326
6. When computers sort data, they always use ____ values when making comparisons between
values.
a. numeric c. alphabetic
b. alphanumeric d. binary
ANS: A PTS: 1 REF: 326
7. Because “A” is always less than “B”, alphabetic sorts are ____ sorts.
a. descending c. ascending
b. reversing d. downward
ANS: C PTS: 1 REF: 327
8. To correctly swap two values, you create a(n) ____ variable to hold one of the values.
a. per-swap c. conversion
b. inversion d. temporary
ANS: D PTS: 1 REF: 328
9. A bubble sort is sometimes called a ____.
a. dropping sort c. ring sort
b. sinking sort d. pair sort
ANS: B PTS: 1 REF: 329
10. In a ____, items in a list are compared with each other in pairs.
a. quick sort c. bubble sort
b. shell sort d. selection sort
ANS: C PTS: 1 REF: 329
11. An array whose elements you can access using a single subscript is a(n) ____ array.
a. one-dimensional c. non-dimensional
b. multi-dimensional d. differential
ANS: A PTS: 1 REF: 346
12. A two-dimensional array contains two dimensions: ____.
a. size and scope c. height and width
b. breadth and height d. depth and width
ANS: C PTS: 1 REF: 346
13. Each element in a two-dimensional array requires ____ subscript(s) to reference it.
a. one c. three
b. two d. four
ANS: B PTS: 1 REF: 347
14. When mathematicians use a two-dimensional array, they often call it a ____ or a table.
a. vector c. ray
TRUE/FALSE
1. The sorting process is usually reserved for a relatively large number of data items.
ANS: F PTS: 1 REF: 326
2. In every popular computer coding scheme, “A” is numerically one greater than “B.”
ANS: F PTS: 1 REF: 326
3. You do not need to determine a record’s exact physical address in order to use it.
ANS: T PTS: 1 REF: 353
4. When a record is removed from an indexed file, it has to be physically removed.
ANS: F PTS: 1 REF: 354
5. Every time you add a new record to a linked list, you search through the list for the correct logical
location of the new record.
ANS: T PTS: 1 REF: 354
MULTIPLE CHOICE
1. When records are in ____ order, they are arranged one after another on the basis of the value in a
particular field.
a. random c. some
b. sequential d. incremental
ANS: B PTS: 1 REF: 326
2. The ____ is used as a statistic in many cases because it represents a more typical case.
a. mode c. average
b. mean d. median
ANS: D PTS: 1 REF: 326
3. The ____ is skewed by a few very high or low values.
a. mode c. mean
b. median d. standard deviation
ANS: C PTS: 1 REF: 326
4. When you store data records, they exist in ____.
a. some type of order
b. the reverse order from how they were entered
c. the same default ordering for all systems
d. a random order
ANS: A PTS: 1 REF: 326
, 5. When you create a ____ report, the records must have been sorted in order by a key field.
a. summary c. detail
b. control break d. control option
ANS: B PTS: 1 REF: 326
6. When computers sort data, they always use ____ values when making comparisons between
values.
a. numeric c. alphabetic
b. alphanumeric d. binary
ANS: A PTS: 1 REF: 326
7. Because “A” is always less than “B”, alphabetic sorts are ____ sorts.
a. descending c. ascending
b. reversing d. downward
ANS: C PTS: 1 REF: 327
8. To correctly swap two values, you create a(n) ____ variable to hold one of the values.
a. per-swap c. conversion
b. inversion d. temporary
ANS: D PTS: 1 REF: 328
9. A bubble sort is sometimes called a ____.
a. dropping sort c. ring sort
b. sinking sort d. pair sort
ANS: B PTS: 1 REF: 329
10. In a ____, items in a list are compared with each other in pairs.
a. quick sort c. bubble sort
b. shell sort d. selection sort
ANS: C PTS: 1 REF: 329
11. An array whose elements you can access using a single subscript is a(n) ____ array.
a. one-dimensional c. non-dimensional
b. multi-dimensional d. differential
ANS: A PTS: 1 REF: 346
12. A two-dimensional array contains two dimensions: ____.
a. size and scope c. height and width
b. breadth and height d. depth and width
ANS: C PTS: 1 REF: 346
13. Each element in a two-dimensional array requires ____ subscript(s) to reference it.
a. one c. three
b. two d. four
ANS: B PTS: 1 REF: 347
14. When mathematicians use a two-dimensional array, they often call it a ____ or a table.
a. vector c. ray
