29:010:485 Sample Midterm Exam 1

Part I. Multiple Choice Questions

1. The purpose of accounting has always been to a. record debits and credits b. provide information useful for economic decision making c. record transactions d. all of the above e. a and c

2. A problem with the traditional accounting model is that it adopts a/an ________ orientation rather than a/an __________ orientation. a. business, user b. transactions, events c. user, transactions d. events, transactions e. events, business

3. The correct sequence of tasks in the accounting process isa. capture transaction data, journalize, post to ledgers, prepare trial balance b. capture transaction data, post to ledgers, journalize, prepare trial balance c. capture transaction data, journalize, prepare trial balance, post to ledgers d. journalize, capture transaction data, post to ledgers, prepare trial balance e. journalize, prepare trial balance, post to ledgers, capture transaction data

2

4. ______________ are temporary stores of transaction information in a manual accounting system. a. Ledgers b. Journals c. Financial statements d. Registers e. Folders

5. Advantages of the database approach include all of the following, EXCEPTa. events orientation b. access to database only by accountants c. support for real-time reporting d. support for ad hoc queries e. support for cross-functional data analysis

6. Which of the following are advantages of computerized bookkeeping over manual bookkeeping? a. greater speed b. improved accuracy c. automatic generation of standard reports d. all of the above e. a and b

7. Every table (data set) must have only one _______.a. non-key attribute b. foreign key c. composite key d. primary key e. candidate key

3

8. If a table (data set) has two unique identifiers, each is called a __________ key.a. primary b. candidate c. composite d. foreign e. concatenated

9. _____________ fields can store any keyboard character. a. Currency b. Boolean c. Date/Time d. Numeric e. Text (alphanumeric)

10. If a data set (table) has only one unique identifier, that unique identifier becomes the __________ of the data set. a. foreign key b. secondary key c. primary key d. non-key attribute e. integrity constraint

11. A data set (table) may have more than one ___________________ but can have only one ____________. a. primary keys, secondary key b. primary keys, concatenated keys c. unique identifiers, primary key d. unique identifiers, secondary key e. primary keys, unique identifiers

4

12. In the relational model (database), if two tables are related, a ____________ must exist in one of the tables. a. composite key b. concatenated key c. foreign key d. numeric field e. text field

13. In a table (data set), a foreign key can be either ___________ or ___________. a. a non-key attribute, part of a composite primary key b. a primary key, a non-key attribute c. single valued, multi-valued d. a primary key, a candidate key e. a duplicate key, a unique key

14. When two or more fields together serve as the primary key in a file, the key is called a a. foreign key b. concatenated key c. secondary key d. candidate key e. none of the above

15. Editing and sorting the data file are steps performed during the ________ stage in the data processing cycle. a. data input b. data processing c. file maintenance d. information output e. data preparation

5

16. For information to have value, it must bea. relevant b. reliable c. unprocessed d. a and b e. a and c

17. __________ represents raw facts, whereas ___________ is data made meaningful. a. Information, reporting b. Data, information c. Information, bits d. Records, bytes e. Bits, bytes

18. (T/F Question) Duplicate rows are allowed.a. True b. False

19. Which of the following are rules for relations in the relational model? a. duplicate rows and columns are not allowed b. relation names must be unique c. the first column in every table must be the primary key d. all of the above e. a and b

6

20. If a vendor can supply many items, and if an item can be supplied by only one vendor, then the relationship going from VENDORS to ITEMS is:a. 1:M b. M:1 c. M:Md. a and b e. none of the above

21. Entries to table fields can be restricted using a. validation rules b. text field format c. digital certificates d. queries e. views

22. In a table, a validation rule that checks whether entries in a field conform to one of a set of acceptable values is referred to as a a. length test b. range test c. field test d. valid combinations test e. validity test

23. All of the following are input devices used in personal computing environments EXCEPT____________. a. keyboard b. trackpad c. trackpoint d. 3D printer e. mouse

7

24. (T/F Question) RAM is the main location for temporary storage of data and instructions.a. True b. False

25. Which of the following is/are components of a CPU? a. arithmetic-logic unit (ALU) b. control unit c. ROM d. all of the above e. a and b

26. A full functioning version of which of the following PC operating systems can be legally downloaded and installed for free? a. Linux b. Mac OS X c. Windows 8 d. Windows 7 e. None of the above