29) To record an inventory order, the information would be entered in a screen that looks similar
to which paper form?
A) Sales receipt
B) Check
C) Invoice
D) Purchase order
30) What is the purpose of an onscreen entry form?
A) Onscreen entry forms allow you to perform data Analysis that is cumbersome in a relational
database.
B) Onscreen entry forms provide predictive modeling to gain insights from data to improve
business decisions.
C) Onscreen entry forms provide a familiar interface for entering information into a database.
D) Onscreen entry forms help ensure information is entered only once in the database.
31) Which accounting software is designed for a large-scale company?
A) Oracle’s PeopleSoft Enterprise
B) SAP Business All-In-One
C) Oracle’s JD Edwards EnterpriseOne
D) SAP Business One
32) When designing a database, which field would NOT belong in a table storing customer
information?
A) First Name
B) Order Number
C) Zip Code
D) Street Address
33) When designing a database, which field would NOT belong in a table storing inventory
information?
A) Cost
B) Part Number
C) Purchase Order
D) Sale Price
34) A database form is a
A) Database screen for data input
B) Database queries
C) Database screen for data output
D) Database searches
35) In an accounting system database, which field belongs in a table containing customer
information?
A) Street Address
B) Cost
C) Item Number
D) Invoice Number
36) A spreadsheet can be viewed as
A) A database form
B) A relational database
C) A flat database
D) A collection of related tables
37) In an accounting system database, which field belongs in a table containing inventory
information?
A) Vendor ID
B) Purchase Order
C) City
D) Invoice Number
38) The following field names are part of a table for a company’s inventory. Which field name
could be the primary key for this table?
A) Sales Prices
B) Cost
C) Item ID
D) Vendor ID
39) In a relational database, how are tables connected?
A) By a query statement
B) By network addresses
C) By the tables names
D) By fields that are common in two or more tables
40) The following fields are common to tables storing customer, vendor, and employee
information EXCEPT
A) City
B) Area Code
C) Cost
D) State
41) Which field below would NOT be stored in an order table?
A) Customer ID
B) Vendor ID
C) Order ID
D) ItemID
42) What is the purpose of a database query?
A) To search the database to answer a specific question
B) To connect related tables
C) To uniquely identify a record in a database table
D) To provide a format for viewing data
43) What is the purpose of Business Intelligence Technologies?
A) Shadow the accounting system
B) Safeguard information
C) Extract data from databases
D) Find consumer patterns and insights
44) Spreadsheets containing data extracted from a relational database are called what?
A) Shadow data
B) Ghost data
C) Gray data
D) Intelligent
45) Which of the following is NOT considered an information asset?
A) Shadow data systems
B) Business intelligence applications
C) Electronic records
D) None of the above
46) Which act requires publicly traded companies to assess the effectiveness of their internal
controls and have an independent CPA firm audit this assessment?
A) Sarbanes-Oxley Act of 2002
B) The GAAP Act of 1932
C) Wheat Commission
D) Security Exchange Commission Act of 1934
47) What is the purpose of security and controls over information assets?
A) Security and controls are to prevent fraud, unauthorized access, modification, destruction, or
disclosure of information assets.
B) Security and controls are to prevent data analysis.
C) Security and controls are to frustrate employees with legitimate need to access information
assets.
D) Security and controls are to ensure all the information assets are available to all employees.
48) What is data mining?
A) A type of OLAP cube
B) A method for safeguarding information asset
C) A business intelligence tool
D) All the above except C
49) Which of the following statements about data warehouses is false?
A) Data warehouses store vast amounts of enterprise data.
B) Data warehouses permit extensive data analytics to provide business intelligence tools for
improved decision quality.
C) Data warehouses store current and historical data.
D) Data warehouses are not considered an information asset and do not need to be safeguarded.
50) What is the difference between the aerial view and zoom view of an accounting system?
51) Identify the six modules in the baseline accounting system. Which transaction cycle is
associated with each module? What type of transactions are associated with each module?
52) If you were the person entering transactions into an accounting system, why would you want
the input screens to look like paper forms?
53) What are the three database essentials an accounting professional needs to know? Define and
provide an example of each.
54) What are Database Forms, Database Queries, and Database Reports? Please provide an
example of each.
55) What is the purpose of a primary key? What would happen if a relational database was
designed without any primary keys?
56) You are hired by a consulting company to assist in creating an accounting system for a
company that sells exclusively online. List the fields needed for the Customer table and the
Inventory table. Identify the primary key in each table.
57) How are database tables connected in a relational database? How does this help prevent
entering data multiple times? Please provide an example.
58) How can data in an accounting information system improve decision making? Provide
examples of these decisions.
59) What is the difference between data, information, and business intelligence?
60) What are the three vital functions an accounting system servers? Please define each.
61) What are the advantages and disadvantages of using a shadow data system?
62) What may be classified as an information asset? Please provide an example.
1) Processes are related activities or events that create value.
2) An IT audit includes auditing the System Development Life Cycle (SDLC).
3) What are the three key factors to consider for a successful accounting system?
A) People, budget, and time
B) Time, processes, and technology
C) People, processes, and technology
D) Processes, budget, and time
4) Which of the following agents is internal to a company?
A) Customer
B) Employee
C) Vendor
D) Investor
5) IFRS is an acronym for
A) Integrated Financial Reporting Services
B) International Financial Reporting Standards
C) Integrated Federal Recording Standards
D) International Financial Regulated Services
6) Which of the following processes are performed in the Designing Phase of the SDLC?
A) Identify the new business processes
B) Install the new system
C) Test the new system
D) Identify the new requirements for the system
7) The staffing process occurs in which phase of the SDLC?
A) Build/Buy Phase
B) Deploy Phase
C) Analyze Phase
D) Plan Phase
8) Analyzing the impact an accounting system will have on people should occur in which phase
of the SDLC?
A) Deploy
B) Design
C) Analyze
D) Planning
9) IT ________ is the design or blueprint for an enterprise’s information technology.
A) Technology
B) Infrastructures
C) Network
D) Architecture
10) Identify the people involved in an accounting system. What type of transactions do they
generate?
11) What are the six main phases in the System Development Life Cycle. What happens in each
phase?