Deck 14: Master File Update Processing

Question 1

In a sequential master file update procedure,when the transaction key is equal to the master key,which of the following is true?

A)The master record is either deleted or updated with the data from the transaction record.
B)The transaction record is added to the master file.
C)There are no more transaction records that affect the current master record.
D)The next master record is read.

Answer 1

A

Question 2

In a sequential master file update procedure,when the transaction key is greater than the master key,which of the following is true?

A)The master record is either deleted or updated with the information from the transaction record.
B)The transaction record is added to the master file.
C)There are no more transaction records that affect the current master record.
D)The next transaction record is read.

Answer 2

C

Question 3

The portion of a record that contains the data that is used to arrange the records in sequence is called a(n)

A)key field
B)search key
C)pointer
D)access key

Answer 3

A

Question 4

In a sequential master file update procedure,when the transaction key is less than the master key,which of the following is true?

A)The master record is either deleted or updated with the information from the transaction record.
B)The transaction record is added to the master file.
C)There are no more transaction records that affect the current master record.
D)The next master record is read.

Question 5

Updating a master file is called file maintenance.

Question 6

Given the following master file containing employee names (key field)and hourly rates and given the following transaction file,how many total records will there be in the updated master file?
$$\begin{array} { l l l l l } \text { Master File } & & { \text { Transaction File } } & \\\text { John } & 20.00 & \text { Add } & \text { Jim } & 11.00 \\\text { Mary } & 10.00 & \text { Delete } & \text { John } & \\\text { Sue } & 6.00 & \text { Add } & \text { Nancy } & 15.00 \\\text { Tom } & 8.00 & \text { Delete } & \text { Tom } & \\\text { Vince } & 13.00 & \text { Add } & \text { Tom } & 13.00 \\& & \text { Change } & \text { Vince } & 14.00\end{array}$$

A)5
B)6
C)7
D)8

Question 7

When a new master file is created and then later used as the current master file it is referred to as a

A)transaction file
B)batch file
C)turnaround file
D)detail file

Question 8

A program flowchart describes the relationship of one or more programs and is valuable to people who want to understand the "big picture" of a system.

Question 9

Given the following master file containing employee names (key field)and hourly rates and given the following transaction file,what is the value of Tom's hourly rate in the updated master file?
$$\begin{array} { l l l l l } \text { Master File } & & { \text { Transaction File } } & \\\text { John } & 20.00 & \text { Add } & \text { Jim } & 11.00 \\\text { Mary } & 10.00 & \text { Delete } & \text { John } & \\\text { Sue } & 6.00 & \text { Add } & \text { Nancy } & 15.00 \\\text { Tom } & 8.00 & \text { Delete } & \text { Tom } & \\\text { Vince } & 13.00 & \text { Add } & \text { Tom } & 13.00 \\& & \text { Change } & \text { Vince } & 14.00\end{array}$$

A)8
B)13
C)14
D)21

Question 10

What type of processing requires that records be accessed in the order in which they are stored?

A)direct
B)random
C)sequential
D)both a and b

Question 11

Given the following master file containing employee names (key field)and hourly rates,which of the following transactions would cause an error message to occur?
$$\begin{array}{l}\text { Master File }\\\begin{array} { l l } \text { John } & 20.00 \\\text { Mary } & 10.00 \\\text { Sue } & 6.00 \\\text { Tom } & 8.00 \\\text { Vince } & 13.00\end{array}\end{array}$$

A)Add     Mary      20.00
B)Delete     Mary
C)Delete     Sue
D)Change     Tom     8.00

Question 12

Large volumes of input are collected and processed together as a group in a batch-processing environment.

Question 13

What type of processing must be used on unsorted records?

A)direct
B)random
C)sequential
D)both a and b

Question 14

In an online processing environment the output of a program is used as input to another program.

Question 15

If the execution of a program processes large volumes of input collected as groups or sets,the program is said to operate in a(n)

A)batch processing environment
B)offline processing environment
C)online processing environment
D)on-demand processing environment

Question 16

If the execution of a program is initiated by a user at a terminal or PC to meet the user's problem-solving needs,the program is said to operate in a(n)

A)batch processing environment
B)offline processing environment
C)online processing environment
D)on-demand processing environment

Question 17

What control structure is likely to be used to determine the type of transaction that has been input from a transaction file?

A)nested IFTHEN ELSE
B)sequential IFTHENELSE
C)CASE
D)both a and c

Question 18

File maintenance operations include

A)adding a new student to a school's student file
B)deleting a student from the school's student file
C)changing the address of a current student in the school's student file
D)all of the above

Question 19

Updating a master file is called

A)file maintenance
B)file sorting
C)file allocation
D)all of the above

Question 20

A master file is the same as a detail file.

Question 21

If a file is stored on a disk,the records must be accessed sequentially.

Question 22

An error will occur if an attempt is made to add a transaction record that has the same key field value(s)as a master record that has just been deleted from the master file.

Question 23

If the transaction record key is greater than the master record key then the next transaction record is read and processed against the current master record.

Question 24

The master file records processed by a sequential master file update program must be arranged in sequence based on a key field.

Question 25

CASE tools promote code reusability but do not help increase programmer productivity.

Question 26

If records are processed directly they do not need to be sorted first.

Question 27

If the transaction record key is less than the master record key then the transaction record is added to the master file and a new master file record is read.

Question 28

Transaction records to be processed against a sequential master file must be in the same sequence as the master file records.

Question 29

An error will occur if an attempt is made to add a transaction record to a master file and the record already exists in the master file.

Question 30

A master file update program usually has one input file and two output files.