Question 1

Updating a file uses a process called

Accepted Answer

A) Interactive processing. 
B) Batch processing. 
C) Alternative processing. 
D) Change processing. 
A) Interactive processing. 
B) Batch processing. 
C) Alternative processing. 
D) Change processing. B

Question 2

When adding a record to a sequential file,it is added to end of the file.

Accepted Answer

A) True 
 B)False  False

Question 3

Updating a file means to only add new records.

Accepted Answer

A) True 
 B)False  False

Question 4

A sequential file is updated through the use of interactive processing.

Accepted Answer

A) True 
 B)False

Question 5

To update a sequential file,each record must be read sequentially and check to see if it needs updating.

Accepted Answer

A) True 
 B)False

Question 6

The transaction file:

Accepted Answer

A) Is listed in random order. 
B) Is listed in order of the primary key of the master file. 
C) Is listed in order of the first field of the master file. 
D) None of the above. 
A) Is listed in random order. 
B) Is listed in order of the primary key of the master file. 
C) Is listed in order of the first field of the master file. 
D) None of the above.

Question 7

When questions about a record come about,the file that is most import to check is:

Accepted Answer

A) Transaction file. 
B) Activity file. 
C) Old master file. 
D) Backup file. 
E) None of the above. 
A) Transaction file. 
B) Activity file. 
C) Old master file. 
D) Backup file. 
E) None of the above.

Question 8

Errors are written to the error report when:

Accepted Answer

A) The transaction file finishes before the master file. 
B) The master file finishes before the transaction file. 
C) A record is added that has a duplicate to an existing record. 
D) All of the above. 
E) None of the above. 
A) The transaction file finishes before the master file. 
B) The master file finishes before the transaction file. 
C) A record is added that has a duplicate to an existing record. 
D) All of the above. 
E) None of the above.

Question 9

After the completion processing of the program to update a sequential file,

Accepted Answer

A) The old master file is the same as the new master file. 
B) The backup file is the same as the new master file. 
C) The old master file is the same as the backup file. 
D) None of the above. 
A) The old master file is the same as the new master file. 
B) The backup file is the same as the new master file. 
C) The old master file is the same as the backup file. 
D) None of the above.

Question 10

The transaction code:

Accepted Answer

A) Is used to find the correct record in the master file. 
B) Indicates the type of update that is needed: adding a record,changing a record,or deleting a record. 
C) Is used to create the exception report. 
D) All of the above. 
A) Is used to find the correct record in the master file. 
B) Indicates the type of update that is needed: adding a record,changing a record,or deleting a record. 
C) Is used to create the exception report. 
D) All of the above.

Question 11

The activity file holds all of the data to update the master file.

Accepted Answer

A) True 
 B)False

Question 12

Backup files are not important to keep.

Accepted Answer

A) True 
 B)False

Question 13

Records may be added,deleted,or changed during the processing of updating a file.

Accepted Answer

A) True 
 B)False

Question 14

In the process of updating a file

Accepted Answer

A) The file is kept in order of the primary key. 
B) The file order is destroyed. 
C) The file is kept in order of the secondary key. 
D) The file is kept in order of a foreign key. 
A) The file is kept in order of the primary key. 
B) The file order is destroyed. 
C) The file is kept in order of the secondary key. 
D) The file is kept in order of a foreign key.

Question 15

The master file holds all of the data to be updated.

Accepted Answer

A) True 
 B)False

Question 16

An exception report from the sequential update program:

Accepted Answer

A) Lists all of the changed records in the master file. 
B) Lists all of the errors found in updating the master file. 
C) Lists all of the records in the transaction file. 
D) Lists all of the records in the activity file. 
A) Lists all of the changed records in the master file. 
B) Lists all of the errors found in updating the master file. 
C) Lists all of the records in the transaction file. 
D) Lists all of the records in the activity file.

Question 17

In order to update a file,it must be created first and have records added.

Accepted Answer

A) True 
 B)False

Question 18

A systems flowchart show the flow of data between hardware units and software.

Accepted Answer

A) True 
 B)False

Question 19

When updating a sequential file:

Accepted Answer

A) The transaction primary key is compared to the new master primary key. 
B) The activity primary key is compared to the old master primary key. 
C) The transaction primary key is compared to the old master primary key. 
D) None of the above. 
A) The transaction primary key is compared to the new master primary key. 
B) The activity primary key is compared to the old master primary key. 
C) The transaction primary key is compared to the old master primary key. 
D) None of the above.

Question 20

The backup file:

Accepted Answer

A) Is made from the old master file. 
B) Is important to keep. 
C) Does not include the updates to the master file. 
D) All of the above. 
A) Is made from the old master file. 
B) Is important to keep. 
C) Does not include the updates to the master file. 
D) All of the above.

Updating a file uses a process called

When adding a record to a sequential file,it is added to end of the file.

Updating a file means to only add new records.

A sequential file is updated through the use of interactive processing.

To update a sequential file,each record must be read sequentially and check to see if it needs updating.

The transaction file:

When questions about a record come about,the file that is most import to check is:

Errors are written to the error report when:

After the completion processing of the program to update a sequential file,

The transaction code:

The activity file holds all of the data to update the master file.

Backup files are not important to keep.

Records may be added,deleted,or changed during the processing of updating a file.

In the process of updating a file

The master file holds all of the data to be updated.

An exception report from the sequential update program:

In order to update a file,it must be created first and have records added.

A systems flowchart show the flow of data between hardware units and software.

When updating a sequential file:

The backup file:

General Problem-Solving Concepts

Beginning Problem-Solving Concepts for the Computer

Planning Your Solution

An Introduction to Programming Structure

Problem Solving With the Sequential Logic Structure

Problem Solving With Decisions

Problem Solving With Loops

Processing Arrays

Sorting,stacks,and Queues

File Concepts

Linked Lists

Binary Trees

Database Management

Relational Database Management Systems

Concepts of Object Oriented Programming

Object Oriented Program Design

Introduction to Concepts of Game Development Using Object Oriented Programming

Introduction to Assembly Language

Sequential-Access File Applications

Filters

Exam 20: Sequential File Updating

Updating a file uses a process called

When adding a record to a sequential file,it is added to end of the file.

Updating a file means to only add new records.

A sequential file is updated through the use of interactive processing.

To update a sequential file,each record must be read sequentially and check to see if it needs updating.

The transaction file:

When questions about a record come about,the file that is most import to check is:

Errors are written to the error report when:

After the completion processing of the program to update a sequential file,

The transaction code:

The activity file holds all of the data to update the master file.

Backup files are not important to keep.

Records may be added,deleted,or changed during the processing of updating a file.

In the process of updating a file

The master file holds all of the data to be updated.

An exception report from the sequential update program:

In order to update a file,it must be created first and have records added.

A systems flowchart show the flow of data between hardware units and software.

When updating a sequential file:

The backup file:

General Problem-Solving Concepts

Beginning Problem-Solving Concepts for the Computer

Planning Your Solution

An Introduction to Programming Structure

Problem Solving With the Sequential Logic Structure

Problem Solving With Decisions

Problem Solving With Loops

Processing Arrays

Sorting,stacks,and Queues

File Concepts

Linked Lists

Binary Trees

Database Management

Relational Database Management Systems

Concepts of Object Oriented Programming

Object Oriented Program Design

Introduction to Concepts of Game Development Using Object Oriented Programming

Introduction to Assembly Language

Sequential-Access File Applications

Filters