Deck 7: File Handling and Applications

Question 1

____ are groups of fields that go together for some logical reason.

A)Tables
B)Databases
C)Columns
D)Records

Answer 1

D

Question 2

When you copy data from RAM into a file on a storage device, you read to the file.

Answer 2

False

Question 3

You update the transaction file with data from the master file.

Answer 3

False

Question 4

You can merge more than two files.

Question 5

The keyboard and printer are the default input and output devices.

Question 6

The terms "parent" and "child" can refer to file backup generations, but they are also used for a different purpose in object-oriented programming.

Question 7

To write a program that produces a report of employees by department number, the records must be grouped by department number before you begin processing.

Question 8

____ storage is not lost when a computer loses power.

A)Temporary
B)Intermediate
C)Permanent
D)Variable

Question 9

When you write a program that stores a value in a variable, you are using ____ storage.

A)permanent
B)temporary
C)resilient
D)resident

Question 10

Files in which records must be accessed immediately are sometimes called instant access files.

Question 11

____ is the more general term for an entity that organizes files.

A)Hierarchy
B)Path
C)Structure
D)Directory

Question 12

Programmers usually use the word "write" to mean "produce hard copy output."

Question 13

Images and music are contained in binary files.

Question 14

You can easily merge files even if each file contains a different record layout.

Question 15

A database holds related file data in ____ .

A)fields
B)records
C)control breaks
D)tables

Question 16

The combination of the disk drive plus the complete hierarchy of directories in which a file resides is its ____.

A)pointer
B)path
C)locator
D)stream

Question 17

A ____ is a collection of data stored on a nonvolatile device in a computer system.

A)computer message
B)computer interface
C)computer file
D)computer selector

Question 18

Files exist on ____ storage devices, such as hard disks, DVDs, USB drives, and reels of magnetic tape.

A)permanent
B)transient
C)scalable
D)optical

Question 19

Characters are made up of smaller elements called ____.

A)fields
B)records
C)bits
D)bytes

Question 20

Directories and ____ are organization units on storage devices.

A)folders
B)files
C)partitions
D)streams

Question 21

When the records in a file are sorted in order from lowest to highest values, the records are in ____ order.

A)descending
B)bubble
C)ascending
D)merged

Question 22

A ____ is a temporary detour in the logic of a program.

A)sequence break
B)control break
C)control sequence
D)break control

Question 23

A ____ is a copy that is kept in case values need to be restored to their original state.

A)read-only file
B)backup file
C)primary file
D)secondary file

Question 24

A ____ break is a break in the logic of the program that is based on the value of a single variable.

A)multiple-level control
B)simple control
C)serial control
D)single-level control

Question 25

____ applications require that a record be accessed immediately while a client is waiting.

A)Real-time
B)Batch
C)Database
D)Sort

Question 26

When you ____ a file, it is no longer available to your application.

A)examine
B)rewrite
C)close
D)index

Question 27

When a program uses a ____, it reads all the records in the file from beginning to end, processing them one at a time.

A)random access file
B)serial file
C)retired file
D)sequential file

Question 28

To generate a control break report, your input records must be organized in ____ order based on the field that will cause the breaks.

A)random
B)ascending
C)sequential
D)repeatable

Question 29

____ files involves combining two or more files while maintaining the sequential order of the records.

A)Merging
B)Sorting
C)Splitting
D)Dividing

Question 30

In most programming languages, before an application can use a data file, it must ____.

A)open the file
B)close the file
C)read the file
D)prepare the file

Question 31

Because they enable you to locate a particular record directly (without reading all of the preceding records), random access files are also called ____ files.

A)direct access
B)indirect access
C)sequential access
D)pointed access

Question 32

A program in which the user makes direct requests is a(n)____________________ program.

Question 33

When you store data in a computer file on a persistent storage device, you ____________________ to the file.

Question 34

When businesses store data items on computer systems, they are often stored in a framework called the data ____________________ that describes the relationships between data components.

Question 35

When you copy data from a file on a storage device into RAM, you are ____ from the file.

A)writing
B)uploading
C)outputing
D)reading

Question 36

The saved version of a master file is the ____ file; the updated version is the child file.

A)peer
B)subordinate
C)parent
D)child

Question 37

A(n)____________________ file holds more temporary data than a master file.

Question 38

A(n)____________________ is a small unit of storage that, for example, holds only one character in a simple text file.

Question 39

The ____ file holds temporary data that is used to update the master file.

A)directory
B)transaction
C)merge
D)database

Question 40

____ is processing that involves performing the same tasks with many records, one after the other.

A)Volume processing
B)Batch processing
C)Online processing
D)Standard processing

Question 42

What is a database?

Question 43

How do you merge two alphabetically ordered input files into a new output file when you wish the output file to be in alphabetical order?

Question 44

Define and give examples of text files and binary files.

Question 45

How are the keyboard and monitor used in most programming languages?

Question 46

What happens when you fail to close an output file?

Question 51

Describe what is required to merge more than two files.

Question 54

List and describe three characteristics that all files have in common.

Question 55

Explain the difference in how programmers use the words print , write , and display .

Question 56

Why might programmers use a control break program?

Question 58

What does the term batch processing mean?