When programming, we need to be able to create and modify persistent files. Data is normally stored in a serial order and this can be re-organised to make it easier to work with.
What type of file has data stored in the order in which it is recorded?
How is a serial file searched?
What is a sequential file?
One that has data in a sequence that has been sorted by a field
One that has data in the sequence in which it is stored
One that has data accessed in sequence
How can we reduce the time it takes to search a file?
By sorting the data into order
By including indexes
By sorting the data into a sequence
Which of the following is true?
Indexes make it quicker to add new records but slow down searches
Indexes speed up searches and make it quicker to add new records
Indexes speed up searches but make it slower to add new records
Which of the following SQL statements allow a user to include an index in a file?
Which data structure is used to store an index?
Before a file can be read, what must be first done to it?
The file must be sequenced
The file must be sorted
The file must be opened
Given the numbers 1-20, how many steps will a binary search take to find the number 13?
Given the numbers 1-20, what will be the result after three steps using a binary search?
10, 11, 12, 13
12, 13, 14
11, 12, 13, 14