Question 1

Updating a master file is called

Accepted Answer

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

Question 2

A master file is the same as a detail file.

Accepted Answer

A) True 
 B)False  False

Question 3

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)

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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)

Accepted Answer

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

Question 6

File maintenance operations include

Accepted Answer

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 
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 7

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.

Accepted Answer

A) True 
 B)False

Question 8

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}$$

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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. 
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.

Question 16

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}$$

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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. 
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.

Question 20

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

Accepted Answer

A) True 
 B)False

Updating a master file is called

A master file is the same as a detail file.

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)

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

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)

File maintenance operations include

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.

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

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.

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

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

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.

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

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

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

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

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

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

Introduction to Structured Design

Simple Sequence Control Structure

Ifthenelse Control Structure

Dowhile Control Structurecounter-Controlled Loops

Dowhile Control Structuretrailer Record Logic

Modularization

Case Control Structure

Dountil Control Structure

Introduction to Arrays

Introduction to Object-Oriented Design

Inheritance

Other Class and Object Relationships

Array Applications

Control-Break Processing

Filters

Exam 14: Master File Update Processing

Updating a master file is called

A master file is the same as a detail file.

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)

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

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)

File maintenance operations include

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.

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

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.

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

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

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.

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

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

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

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

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

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

Introduction to Structured Design

Simple Sequence Control Structure

Ifthenelse Control Structure

Dowhile Control Structurecounter-Controlled Loops

Dowhile Control Structuretrailer Record Logic

Modularization

Case Control Structure

Dountil Control Structure

Introduction to Arrays

Introduction to Object-Oriented Design

Inheritance

Other Class and Object Relationships

Array Applications

Control-Break Processing

Filters