Deck 10: File Concepts

Question 1

22.When processing records sequentially

A)The records are processed one at a time starting with the first record.
B)The fields are processed one at a time starting with the first field.
C)The records are processed one at a time starting anywhere in the file.
D)The fields are read one at a time starting anywhere in the record.

Answer 1

A

Question 2

16.Files may be processed:

A)Sequentially.
B)Randomly through the use of linked lists.
C)Randomly through the use of binary trees.
D)All of the above.
E)None of the above.

Answer 2

D

Question 3

6.Random access files may process records randomly or sequentially.

Answer 3

True

Question 4

9.It is important to design the record with care to save storage space.

Question 5

7.A secondary key is essentially the same as a primary key.

Question 6

5.The EOF is a marker after the last record in a file.

Question 7

4.A systems flowchart uses the same symbols as an algorithmic flowchart.

Question 8

14.A data record dictionary:

A)Is a list of the terms used in the solution.
B)Is a list of fields in a record and their attributes.
C)Is a list of the data found in the records.
D)Is a list of records in a file and their attributes.

Question 9

1.Sequential access file may be processed either randomly or sequentially.

Question 10

19.The secondary key

A)Is unique.
B)May be used to access records.
C)Is used within the record only.
D)Is the same as the primary key.

Question 11

15.The primer read is the first record that:

A)Is read as the last instruction in the loop.
B)Is read after the loop ends.
C)Is read as the first instruction in the loop.
D)Is read before the loop begins.

Question 12

3.The logical file number is a reference number used in the solution.

Question 13

10.A systems flowchart shows the flow of data between the pieces of hardware.

Question 14

12.A primary key:

A)Is required for all types of files.
B)Should be unique.
C)Is used in conjunction with a secondary key and is less important than the secondary key.
D)Is the only field used to sort the records of a file.

Question 15

13.A systems flowchart:

A)Shows the data flow through the complete hardware system.
B)Shows the data flow through the program instructions.
C)Shows the data flow through the modules.
D)Shows the data flow through the internal memory.

Question 16

8.Instructions such as OPEN and READ uses the LFN within the solution since that number designates the file in use.

Question 17

2.Sorting is the processing categorizing the data.

Question 18

17.Buffers are

A)Allow data to be transferred from one storage device to another storage device.
B)Are only used when processing files sequentially.
C)Data holding areas in the computer.
D)All of the above.
E)None of the above.

Question 19

21.The fields of a record

A)Contain like data for all records.
B)Contain different pieces and number of data items for each record.
C)Contain only character or string data.
D)Contain only numeric data.

Question 20

11.A random access file:

A)Can be accessed sequentially.
B)Uses many methods of accessing records including linked lists and binary trees.
C)Can access any record without reading through any other records.
D)All of the above.

Question 21

23.Sequential files

A)Start with a given record number and continues until the file is closed.
B)Start with the first record and end with and EOF.
C)Start with the first record and ends with a file closed instruction.
D)All of the above.

Question 22

24.Sequential files can be processed and maintained

A)As efficiently as random accessed files.
B)More efficiently as random access files.
C)Less efficiently as random access files.
D)As efficiently as random accessed files in some applications.