CS113 - Ch08 Review - Advanced Data Handling Concepts

25 July 2022
4.7 (114 reviews)
56 test answers

Unlock all answers in this set

Unlock answers (52)
question
Control Break
answer
When you create a ____ report, the records must have been sorted in order by a key field.
question
Insertion Sort
answer
In a(n) ____, if an element is out of order relative to any of the items earlier in the list, you move each earlier item down one position and then insert the tested element.
question
Sequential Order
answer
Arranging records one after another based on the value in a particular field.
question
Ascending Order
answer
Arranging records from lowest to highest value within a field.
question
Descending Order
answer
Arranging records from highest to lowest value within a field.
question
Median
answer
The value of the middle item when the values are listed in order.
question
Mean
answer
The arithmetic average.
question
Algorithm
answer
A list of instructions that accomplish a task.
question
Table
answer
A two-dimensional array.
question
Physical Order
answer
A "real" order for storage.
question
Logical Order
answer
A virtual order based on any criterion you choose.
question
Addresses
answer
Used to identify computer memory and storage locations.
question
Algorithm
answer
A(n) ____________________ is a list of instructions that accomplishes a task.
question
Sequential
answer
When records are in ____ order, they are arranged one after another on the basis of the value in a particular field.
question
Height and Width
answer
A two-dimensional array contains two dimensions: ____.
question
Sort Records as a Whole
answer
When you sort records, two possible approaches are to place related data items in parallel arrays and to ____.
question
True
answer
When a large data file needs to be processed in ascending or descending order based on a particular field, the most efficient approach is usually to store and access records based on their logical order.
question
One-Dimensional
answer
An array whose elements you can access using a single subscript is a ____ array.
question
Index and Linked List
answer
A common method of accessing records in logical order is to use a(n) ____.
question
Median
answer
The ____ is often used as a statistic in many cases because it represents a more typical case.
question
True
answer
Two-dimensional arrays are never actually required in order to achieve a useful program.
question
False
answer
The most popular computer coding schemes include ASCII, Numeric, and EBCDIC.
question
Multidimensional Arrays
answer
____ are arrays that have more than one dimension.
question
Linked
answer
In its simplest form, creating a(n) ____________________ list involves creating one extra field in every record of stored data.
question
Sinking Sort
answer
A bubble sort is sometimes called a ____.
question
Logical
answer
Every time you add a new record to a linked list, you search through the list for the correct ____ location of the new record.
question
Mean
answer
The ____ is skewed by a few very high or low values.
question
False
answer
An insertion sort is another name for a bubble sort.
question
Linked List
answer
One way to access records in a desired order, even though they might not be physically stored in that order, is to create a(n) ____.
question
Temporary
answer
To correctly swap two values, you create a(n) ____ variable to hold one of the values.
question
All elements in the array are already in the correct order
answer
When using a bubble sort to sort a 10-element array, on the fourth pass through the array list you detect that no swap has occurred. This indicates ____.
question
Matrix
answer
When mathematicians use a two-dimensional array, they often call it a ____ or a table.
question
False
answer
It is relatively easy for people to keep track of arrays with more than three dimensions.
question
Ascending
answer
Because "A" is always less than "B", alphabetic sorts are ____ sorts.
question
Some type of order
answer
When you store data records, they exist in ____.
question
False
answer
The sorting process is usually reserved for a relatively large number of data items.
question
True
answer
Some programming languages allow multidimensional arrays.
question
Ascending
answer
If you are performing a(n) ____________________ bubble sort, then after you have made one pass through the list, the largest value is guaranteed to be in its correct final position at the bottom of the list.
question
Addresses
answer
As pages in a book have numbers, computer memory and storage locations have ____.
question
Bubble Sort
answer
In a ____, items in a list are compared with each other in pairs.
question
True
answer
When a record is removed from an indexed file, it has to be physically removed.
question
Key
answer
A record's ____ field is the field whose contents make the record unique among all records in a file.
question
Two
answer
Each element in a two-dimensional array requires ____ subscript(s) to reference it.
question
Index
answer
When you ____ records, you store a list of key fields paired with the storage address for the corresponding data record.
question
Numeric
answer
When computers sort data, they always use ____ values when making comparisons between values.
question
True
answer
You can make additional improvements to a bubble sort to reduce unnecessary comparisons.
question
Logical
answer
Every time you add a new record to a linked list, you search through the list for the correct ____ location of the new record.
question
An array that has only one dimension because its data can be stored in a table that has just one dimension - height.
answer
Describe a one-dimensional array.
question
myArray[customerNumber][name], where customer number is the index number and the name is either 0 or 1. First name could be 0 and last 1. myArray[0][0] is joshua, myArray[0][1] is windle. customerNumber is the first subscript and name is the second subscript.
answer
Describe how you access a two-dimensional array value using two subscripts.
question
Random-Access
answer
When you use an index, you can store records on a ____ storage device.
question
one-dimensional arrays are declared with a single subscript or index. two-dimensional arrays are declared using two separate subscripts.
answer
Discuss how you declare one-dimensional and two-dimensional arrays.
question
They have both rows and columns of values; you must use two subscripts when you access an element in a two-dimensional array.
answer
Describe a two-dimensional array.
question
If there is a list of records that were imputed in order based on the first customer who came in but now they need to be sorted by highest amount due for bill. You would sort them by the highest amount due.
answer
Give an example of an occasion when you would need to sort records.
question
Algorithm
answer
When you learn a method like sorting, programmers say you are learning a(n) ____.
question
swap
answer
When you ____________________ values stored in two variables, you exchange their values.
question
False
answer
You do not need to determine a record's exact physical address in order to use it.