Ch 2 MC

A database deadlock? a) is a lock placed on a record to prevent it from being accessed by other processes b) occurs when two records are accidentally assigned the same primary key c) occurs when a unique record is accessed by several different process simultaneously d) is none of the above

A

Which is least appropriate type of transaction for a real-time system?a) airline reservations b) payroll c) point-of-sale transactions d) air traffic control systems e) all of these applications typically utilize real time processing

B

Which statement is NOT true in Batch processing? a) permits data to be edited in a separate computer run b) is subject to deadlocks when processing common accounts c) can use databases and flat files d) can be initiated from a terminal

B

An invoice file would best be coded using a(n) coding _________ scheme? a) alphabetic b) mnemonic c) block d) sequential

D

(Appendix Quesiton) 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 requried

a

(a q) An advantage of a physical address pointer is that a. it points directly to the actual disk storage location b. it is easily recovered if it is inadvertently lost c. it remains unchanged when disks are reorganized d. all of the above are advantages of the physical address pointer

a

A document tool that depicts the physical flow of information relating to a particular transaction through an organization is a: a. system flowchart b. program flowchart c. decision table d. data flow diagram e. systems survey

a

Which of the following files is a temporary file? a. transaction file b. master file c. reference file d none of the above

a

Which of the following is NOT a true statement? a. transactions are recorded on source documents and are posted to journals b. transactions are recorded in journals and are posted to ledgers c. infrequent transactions are recorded in the general journal d. frequent transactions are recorded in special jorunals

a

A coding scheme in the form of acronyms and other combinations that convey meaning is a(n) a. sequential code b. block code c. alphabetic code d. mnemonic code

b

Real-time systems might be appropriate for all of the following EXCEPT: a. airline reservations b. payroll c. point-of-sale transactions d. air traffic control systems e. all of these applications typically utilize real-time processing

b

The production subsystem of the conversion cycle includes all of the following EXCEPT a. determining raw materials requirements b. make or buy decisions on component parts c. release of raw materials into production d.. scheduling the goods to be produced

b

Which of the following statements is NOT true? a. sorting records that are coded alphabetically tends to be more difficult for users than sorting numeric sequences b. mnemonic coding requires the user to memorize codes c. sequential codes carry no information content beyond their order in the sequence d. mnemonic codes are limited in their ability to represent items within a class

b

is the system flowchart symbol for: a. on page connector b. off page connector c. home base d. manual operation e. document

b

(a q) In a hashing structure a. two records can be stored a the same address b. pointers are used to indicate the location of all records c. pointers are used to indicate location of a record with the same address as another record d. all locations on the disk are used for record storage

c

(appendix question)Which statement is NOT correct? The indexed sequential access method. a. is used for very large files that need both direct access and batch processing b. may use an overfllow area for records c. provides an exact physical address for each record d. is appropriate for files that require few insertions or deletions

c

A chart of accounts would best be coded using a (n)______coding scheme a. alphabetic b. mnemonic c. block d. sequential

c

A documentation tool used to re-preset the logical elements of a system is a(n): a. programming flowchart b. entitle relationship diagram c. system flowchart d. data flow diagram

c

Appendix Question) 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,

c

Which of the following is NOT true of a turn-around document? a. they may reduce the number of errors made by external parties b. they are commonly used by utility companies (gas, power, water) c. they are documents used by internal parties only d. they are both input an output doucments

c

Which of the following is true of the relationship between subsidiary ledgers and general ledger accounts? a. the two contain different and unrelated data b. all general ledger accounts have subsidiaries c. the relationship between the two provides an audit trail from the financial statements to the source documents d. the total of subsidiary ledger accounts usually exceeds the total in the related general ledger account

c

Which of the following statements is not correct? a. database systems resolve task data dependency b. the flat-file model encourages data redundancy c. the database approach uses one common database to promote the concept of single user view d. a primary goal of database systems is to minimize data redundancy e. database systems provide increased accessibility to data and data intergration

c

Which statement is not true? a. Business activities begin with the acquisition of materials, property, and labor in exchange for cash b. The conversion cycle includes the task of determining raw materials requirements c. Manufacturing firms have a conversion cycle but retail firms do not d. A payroll check is an example of a product document of the payroll system e. A journal voucher is actually a special source document

c

Which of the following is NOT an advantage of real-time processing of files over batch processing? a. shorter transaction processing time b. reduction of inventory stocks c. improved customer service d. all are advantages

d

Which statement is NOT correct? a. Legacy systems may process financially significant transactions b. Some legacy systems use database technology c. Mainframes are exclusive to legacy systems while modern systems use only the client-server model d. all the above are true

d

Batch processing will not permit: a. data to be edited on a separate computer run b. the use of a database structure c. data to be edited in an offline mode d. batch processing to be initiated from a terminal e. data to be edited on a real-time basis

e