Which statement is NOT correct? The indexed sequential access methoda. is used for very large files that need both direct access and batch processing.b. may use an overflow area for records.c. provides an exact physical address for each record.d. is appropriate for files that require few inser- tions or deletions.

Which statement is NOT correct? The indexed sequential access methoda. is used for very large files that need both direct access and batch processing.b. may use an overflow area for records.c. provides an exact physical address for each record.d. is appropriate for files that require few inser- tions or deletions.

Accounting Information Systems

10th Edition

ISBN:9781337619202

Author:Hall, James A.

Publisher:Hall, James A.

Chapter2: Introduction To Transaction Processing

Section: Chapter Questions

Problem 2MCQ

See similar textbooks

Similar questions

Which statement is NOT correct?a. Indexed random files are dispersed throughout the storage device without regard for physical proximity with related records.b. Indexed random files use disk storage space efficiently.c. Indexed random files are efficient when processing a large portion of a file at one time.d. Indexed random files are easy to maintain in terms of adding records.
Which statement is NOT true? Batch processinga. is subject to deadlocks when processing commonaccounts.b. permits data to be edited in a separate computerrun.c. can use databases and flat files.d. can be initiated from a terminal.
A transitive dependencya. is a database condition that is resolved through special monitoring software.b. is a name given to one of the three anomalies that result from unnormalized database tables.c. can exist only in a table with a composite primary key.d. cannot exist in tables that are normalized at the 2NF level.e. is none of the above.
Which statement is true about a hashing structure? a. The same address could be calculated for two records. b. Storage space is used efficiently. c. Records cannot be accessed rapidly. d. A separate index is required.
Repeating group dataa. is a form of data redundancy common to replicated databases in a distributed database environment.b. is a name given to one of the three anomalies that result from unnormalized database tables.c. can exist only in a table with a composite primary key.d. cannot exist in tables that are normalized at the 2NF level.e. is none of the above.
A partial dependency a. is the result of simultaneous user requests for the same data in a partitioned database environment. b. is a name given to one of the three anomalies that result from unnormalized database tables. c. can exist only in a table with a composite primary key. d. may exist in tables that are normalized at the 2NF level. e. is none of the above.
Which of the following statements is not correct? a.The database approach uses one common database to promote the concept of single user view. b.Database systems resolve task data dependency. c.The flat-file model encourages data redundancy. d.A primary goal of databasesystems is to minimize data redundancy. e.Database systems provide increased accessibility to data and data integration.
Describe the three types of anomalies associated with database tables that have not been normalized. Using and Inventory table as an example, explain the operational implications of each anomaly.
The database approach has several unique characteristics not found in traditional (flat-file) systems. Which of the following statements does not apply to the database model? a. Database systems have data independence; that is, the data and the programs are maintained separately except during processing. b. Database systems contain a data-definition language that helps describe each schema and subschema. c. The database administrator is the part of the software package that instructs the operating aspects of the program when data are retrieved. d. A primary goal of database systems is to minimize data redundancy. e. Database systems provide increased accessibility to data and flexibility in its usage.