|
Files and Processing
1. A payroll system's master file is stored on tape. The payroll is processed at night once every 2 weeks. There is relatively little file maintenance required. Which of the following is most likely to be the approprite processing method under the circumstances?
a. Parallel
b. Online, real-time
c. Network
d. Batch
2. A company updates the payroll master file at the end of the week. The payroll time cards are transported to the computer center for processing. The sequence of events followed by the computer center in updating its master file should be
a. Converting to machine-readable form, batching records of transactions, validating input, updating the master
b. Batching records of transactions, converting to machine-readable form, validating input, updating the master
c. Validating input, batching records of transactions, converting to machine-readable form, updating the master
d. Batching records of transactions, validating input, converting to machine-readable form, updating the master
3. Sequential access means that
a. Data are stored on magnetic tape
b. The address of the location of data is found through the use of either an algorithm or an index
c. Each record can be accessed in the same amount of time
d. To read record 500, records 1 through 499 must be read first
4. A new purchasing system for just-in-time production requirements has been proposed. Users want access to current master file information at all times. To satisfy user needs, master file changes should be implemented with
a. Periodic entry with subsequent batch processing
b. Periodic entry with immediate batch processing
c. Online entry with subsequent batch processing
d. Online entry with immediate processing
5. Of the following, the greatest advantage of a database architecture is
a. Data redundancy can be reduced
b. Conversion to a database system is inexpensive and can be accomplished quickly
c. Multiple occurrences of data items are useful for consistency checking
d. Backup and recovery procedures are minimized
6. A firm maintains facts and figures on its sales, costs nd personnel in various computer files. Collectively, these files are called the firm's
a. MIS
b. DSS
c. Data schem
d. Database
7. To trace data through several application programs, an auditor needs to know what programs use the data, which files contain the data, and which printed reports display the data. If data exist only in a database system, the auditor could probably find all of this information in a
a. Data dictionary
b. Database schema
c. Data encryptor
d. Decision table
8. Which of the following would not normally be considered a typical file structure for a database management system?
a. Relational structure
b. Hierarchical structure
c. Network structure
d. Batched sequential structure
9. Which of the following database models is considered to be the most versatile?
a. Hierarchical model
b. Tree model
c. Network model
d. Relational model
10. A business has decided to use magnetic disks to store accounts receivable information. What data file concepts should be used to provide the ability to answer customer inquiries as they are received?
a. Sequential storage and chains
b. Sequential storage and indexes
c. Record keys, indexes and pointers
d. Inverted file structure, indexes, and internal labels
Answers-File Management - D
- B
- D
- D
- A
- D
- A
- D
- D
- C
|
