AIS MC Quizzes Midterm

Which of the following diagrams most accurately illustrates an information system?

\
Design > Prototype > Feedback > User

Design > Build > Test > Implement

Input > Process > Storage > Output

Economic Event > Journal > Ledger > Financial Report

Input > Process > Storage > Output

The primary transformation of data into information takes place in which of the following activities?

\
Input

Storage

Processing

Output

Processing

A simple information system includes all of the following elements except

\
Processing

Storage

Input

Reporting

Reporting

The Information Value Chain is defined as:

\
The flow of materials, information, payments, and services

The use of computer technology to provide information about business activities to employees across the firm

The overall transformation of data from a business need to the ultimate decision

A centralized database that collects data throughout the firm

The overall transformation of data from a business need to the ultimate decision

The role of accountants in an accounting information system include all of the following except

\
User

Manager

Coder

Evaluator

Coder

The correct order of effects in the value chain are

\
Inbound logistics > operations > service

inbound logistics > outbound logistics > marketing & sales

inbound logistics > operations > outbound logistics

inbound logistics > operations > shipping

inbound logistics > operations > outbound logistics

One of the most important wats that ERPs benefit organizations and their business processes is:

\
Current information is made available to all users involved in the activities and decisions associated with a company’s business processes

Information is stored in many specialized, distributed databases that each serve separate business processes

Reducing the amount of time to complete business processes by eliminating all controls associated with the processes

Preventing external business partners from accessing the orgnaization’s data

Current information is made available to all users involved in the activities and decisions associated with a company’s business processes

A supply chain system does **not** include information about:

\
Current customers

Prospective customers

Availability of inventory

Current suppliers

Prospective customers

Many fast food restaurants now have kiosks where customers can order without speaking to an employee. This is an example of

\
automate

informate-up

transform

informate-down

automate

The income statements account most likely affected by an AIS investment in customer relationship managements would be

\
Revnues

COGS

Selling, general and administrative expenses

Unearned revenue

Revenues

Which of the following is NOT a type of data model discussed in our material

\
Normalization data model
Network data model
Relational data model
Hierarchical data model

Normalization data model

What kind of data model is most commonly used as a basis for today's enterprise systems?

\
The normalization model

The network model

The relational model

The hierarchical model

The relational model

Which of the following is NOT a construct in a relational database?

\
Records

Attributes

Tables

Forms

Forms

Which of the following  items can best be described as a "Resource" in the REA data model?

 

Purchase

Sales

Cashier

Cash

Cash

Which of the following items can best be described as an "Event" in the REA data model?

 

Cash

Cashier

Customer

Cash Collection

Cash Collection

Which of the following about SQL is INCORRECT?

 

SQL is a language designed to query data in a relational database

SQL is based on relational algebra and allows a user to query and update the database

SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query

SQL uses the PIVOT function to insert data

SQL uses the PIVOT function to insert data

Which of the following about cloud computing is INCORRECT?

 

Data stored in a cloud computing system is always secure

If the internet connection goes down the system will not function

Cloud computing is internet-based computing where shared resources, software, and information are provided to firms on demand

Cloud computing can easily hosts enterprise system applications

Data stored in a cloud computing system is always secure

Which of the following is a correct statement about primary keys?

 

A primary cannot be used in another table as a foreign key

Most tables in a database may not require primary keys

The data values of a primary key must be different (i.e., unique)

A primary is always another table's foreign key

The data values of a primary key must be different (i.e., unique)

Which of the following is a correct statement about foreign keys?

 

An attribute cannot be a foreign key used in different tables

Most foreign keys should not have any data values

A foreign key must be another table's primary key 

All foreign keys cannot not be blank (null)

A foreign key must be another table's primary key 

Name and describe 1 of the 7 ways cloud ERP helps organizations build resilience and agility.  From the Oracle NetSuite White paper we discussed in class.

Cloud ERP helps organizations build resilience and agility by allowing remote work.  This allows the employees to not need to be on-site to access internal databases, and they can access them remotely.  It also utilizes internal controls halt any possible deceptions from employees.  This overall increases the productivity and efficiency of the organization.

Which of the following best described the difference between access controls and application controls?

\
Access controls limit how many records can be changed and application controls ensure segregation of data

Access controls are “prohibited” business roles and application controls are “allowed” business rules

Access controls limit who can change records and application controls ensures data integrity and provide an audit trail of any changes

There is no difference between access and application controls

Access controls limit who can change records and application controls ensures data integrity and provide an audit trail of any changes

Business rules are an example of which COSO concept

\
Internal control

activity models

control environment

control activites

control activities

Sales order 1..\* 0..\* Cash Receipts

A new table will be created that contains both sales order ID and Cash Receipt ID as its composite primary key

Which of the following best describes the purpose of an intermediate error event

\
Shows the interchange between two pools

Depicts the sequence of activities in one pool

Illustrates the process flow when an exception occurs

Contains a series of activities that are hidden from view

Illustrates the process flow when an exception occurs

Which of the following best describes the purpose of a BPMN collapsed sub-process

\
A series of events is hidden from view as the information is not necessary to the model

The collapsed process will be modeled at a later time

A series of events is hidden from view as the information is not well controlled

The collapsed process contains too many errors

A series of events is hidden from view as the information is not necessary to the model

Which of the following events is generally not impacted as part of the sales and collections process

\
Accounts payable

Cash

Accounts recievable

Inventory

Accounts payable

Which of the following is not an example of a business rule?

\
Inventory must be maintained in a secure location

Employee who receives checks can not change invoices

Managers must approve orders over $10,000

The credit department must approve all sales on account

Inventory must be maintained in a secure location

Which of the following best describes the choreography in a BPMN activity diagram

\
Hides the activities that are not of interest in the analysis of business process

Follows the sequence of flow from start to end

Shows the interaction of messages between participants in the business process

Shows the sequence of activities within one pool

\

Shows the interaction of messages between participants in the business process

Product categories 0..\* 1..1 Employees

Each product category has one manager **or** employee can have 0 to many product categories

Products 1..\* 0..\* Order

An order may include many products **or** there are 0 to many products in an order

Which of the following is the best reason that a collaboration model would not be used to diagram the conversion process?

\
All conversion activities are internal to the organization. 

A collaboration model does not include swimlanes.

The orchestration of the activities is not shown in a collaboration model.

The choreography between pools is not shown in a collaboration model.

All conversion activities are internal to the organization. 

Which of the following is the most likely order of a basic conversion activity model?

\
Authorize Production→Issue Raw Materials→Perform Work→Complete Production.

 

Customer Order→Perform Work→Review Work→Ship Product.

 

Authorize Production→Order Materials→Apply Overhead→Complete Production.

 

Customer Order→Issue Raw Materials→Apply Overhead→Ship Product.

Authorize Production→Issue Raw Materials→Perform Work→Complete Production.

Which of the following least reflects the purpose of a business rule in the conversion process?

 

Segregating authorizing, issuing, and conversion work duties.

 

Limiting who can view and change records in the system.

 

Return defective items to suppliers promptly.

 

Assuring that all products meet quality standards.

Return defective items to suppliers promptly.

Products 1..1 0..\* product authoriztion

Each product authorization is related to one product

Start > authorize production > issue raw materials > perform work > complete production > end

\
Conversion process: quantity of raw materials to be released is calculated upon?

\
Work-in-Process.

 

The Bills of Materials.

 

The quantities of raw materials purchased.

 

Economic order quantities.

The Bills of Materials.

Lightening bolt is

\
 

Gateway.

 

Activity loop.

 

Exception event.

 

Collapsed subprocess.

Exception event.

Which of the following is the primary overall objective of the conversion process?

 

Issue raw materials efficiently.

 

Ensure that enough finished products are available to meet anticipated demand.

 

Make finished products to order.

 

Transfer finished goods to warehouse inventory accurately.

Ensure that enough finished products are available to meet anticipated demand.

When creating a UML class diagram to support the conversion process, which of the following approaches provides a way to meet both accounting and general management information requirements?

 

The COSO framework.

 

BPMN guidelines.

 

A star schema.

 

The REA framework.

The REA framework.

Materials 1..\* 0..\* Material Issue

A Material Issue must include at least one material, but may include many materials.

Which of the following is the most likely foreign key for the Bill of Materials table?

 

Prod_auth_ID

\
Product_ID

 

Issue_Sequence

 

Material_description

Product_ID