Midterm Exam

 

1.   The Sarbanes-Oxley Act of 2002 requires that a company’s attest auditors be able to perform which of the following activities?

Evaluate the internal controls in an AIS.

Assess the value of a company’s IT assets.

Take over the company’s AIS if necessary.

Design and implement the controls used in the AIS.

 

2.   The characteristics of relevant information include predictive value, feedback value and timeliness.

Trur or False

 

3 .  Accounting Information Systems which are computerized do not need to maintain internal controls.

 

4.     The IT strategic roles of AIS investments are classified as:

Automate, Informate, Transform.

Value creation, Value Destruction, Value Neutral.

Digitize, Report, Transform.

Automate, Digitize, Transport.

 

 

5.  The Sarbanes-Oxley Act of 2002 is a federal law in the United States that set new and enhanced standards for all U.S. public companies, their management and public accounting firms

True or False

 

6.   As of today, Accounting Information Systems are all computerized.

True or False

 

 

7.  A supply chain system does not include information about:

Current customers.

Prospective customers.

Availability of inventory.

Current suppliers.

 

8.  The Certified Information Technology Professional (CITP) is a professional designation for those with a broad range of technology knowledge and does not require a CPA.

True or False

 

9     An opaque external pool in a BPMN activity diagram is typically used becasue:

The external pool event is not important for the model.

It hides confidential information.

It involves external parties.

The external pool event contains a gateway that is addressed later.

 

 

10.  Which of the following BPMN shapes represents a Parallel Gateway?

 

 

11  Activity models can be used after a new system is implemented.

True or False

 

 

12  A business process does not contain activities.

True or False

 

 

13  Which of the following BPMN shapes represents a data store?

 

14.  Business models are often more difficult to understand than written descriptions of activities.

True or False

 

15.  Activity models are analagous to which of the following?

 

The prototype for a new car model.

A blueprint.

The instructions in a recipe.

A car’s steering system.

 

 

16.   Which of the following best describes the purpose of a gateway in a Business Process Modeling Notation (BPMN) activity diagram?

Shows where the work takes place.

Describes the sequence of workflow.

Affects the flow of the business process.

Controls branching and merging.

 

 

17.   What is the best description of the relationship between instructor and course in the following UML class diagram?

One-to-zero.

One-to-many.

Zero-to-many.

Many-to-many.

 

 

18. Associations can indicate the roles that one Class takes in its business relationship with another Class.

 

 

19   Consider an association indicating professional licensing status between an Accountant class and a States class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Accountants class are 0..* and the multiplicities next to the States class are 0..*. Which of the following is the best way to implement that association in your database?

 

Post the primary key of Accountants as a foreign key in States.

Post the primary key of States as a foreign key in Accountants.

Create a linking table.

None of these choices are correct.

 

 

20 .  Consider an association between a Cash Disbursements class and a Vendors class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Vendors class are 1..1. Which of the following is the best way to implement that association in your database?

Post the primary key of Cash Disbursements as a foreign key in Vendors.

Post the primary key of Vendors as a foreign key in Cash Disbursements.

Create a linking table.

None of these choices are correct.

 

 

21.    Which of the following is not a form of business rules?

Compulsory.

Obligatory.

Prohibited.

Allowed.

 

 

22.   Which of the following is not a step in using a Unified Modeling Language (UML) Class model to prepare a database?

Map Classes to Tables.

Map Attributes to Table Fields.

Map Associations to Primary Keys.

Map Associations to Foreign Keys.

 

 

23.  Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams?

Opt for simplicity.

Use various size class rectangles.

Avoid crossing lines whenever possible.

Avoid confusing abbreviations.

 

 

24.  Three types of data models used today are: the hierarchical model, the network model and the relational model.

True or False

 

 

25.   In Access, users can edit database information in reports.

True or False

 

 

26.   In a database, while queries allow the user to access, read and report on desired data, the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS).

True or False

 

27.    Which type of data models allows each record to have multiple parent and child records?

The hierarchical mode.

The network model.

The relational model.

None of these choices is correct.

 

 

28.  Which of the following correctly describes the Referential Integrity Rule?

The primary key of a table must have data values (cannot be null).

Each attribute in a table must have a unique name.

The data value for a foreign key could be null.

Values of a specific attribute must be of the same type.

 

 

29 .  Which of the following items can best be described as an “Event” in the REA data model?

 

Cash.

Cashier.

Cash collection.

Customer.

 

 

30   Which of the following statements best describes the entity integrity rule?

A database entity must fit within the REA model.

A record’s foreign key value must be null.

A record’s primary key must have a data value.

All values of an attribute must be of the same data type.

 

 

31.  Which of the following is not one of the typical challenges organizations face when implementing an ERP?

Integrating with external business partners’ information systems.

Converting data from legacy systems to the ERP.

Installing the ERP software.

Successfully completing a large project in an organization.

 

 

32.  A pool in a BPMN model does not actually have to display any activities.

True or False

 

 

33.   Segregation of duties is an example of a COSO control activity.

True or False

 

 

34.    Refer to the following diagram. Which of the following answers provides the best interpretation of the multiplicities for the association between the Cash Receipt and Cash classes?

Each cash receipt is deposited into one bank account.

Each order increases accounts receivable.

The company only has one bank account.

Some cash receipts are not deposited into a bank account.

 

35   Refer to the following diagram. Which of the following answers does not provide a valid interpretation of the multiplicities for the association between the Employees and the Sales classes?

Only one employee participates in each sale.

Several employees participate in each sale.

Some employees do not participate in sales.

Some employees participate in several sales.

 

 

36  Which of the following is not something a busines rule would implement?

Segregation of Duties
Authorization
NotificationsCorrect
Approval

 

37  Consider the following diagram. How will the database relationship between Employees and Sales Orders be implemented?

 The Sales Order ID will be included as a foreign key in the Employees table.

The Employee ID will be included as a primary key in the Employees table.

The Sales Order ID will be included as a primary key in the Employees table.

The Employee ID will be included as a foreign key in the Sales Orders table.

 

 

38. Consider the following diagram. Which of the following best describes how the relationship between Sales Orders and Cash Receipts will be implemented in the resulting database?

The Sales Order ID will be included as a foreign key in the Cash Receipts table.

A new table will be created that contains both Sales Order ID and Cash Receipt ID as its composite primary key.

The Cash Receipt ID will be included as a foreign key in the Sales Orders table.

The Cash Receipt Amount field will be included as a foreign key in the Cash Receipts table.

 

 

39    Refer to the following UML class diagram to answer questions 1 to 5 below about the relational database based on this model.

The association between Purchase Orders and Cash Disbursements would be implemented with a linking table.

True or False

 

40.  Which of the following is not a desired access control when developing a purchases and payments business process?

The person placing the purchase order must not receive the items.

The person returning items to the supplier must not view the original purchase order.

The person receiving the order must not see the original purchase order quantities.

The person paying the supplier must not be able to modify the purchase order.

 

 

41.  In the following diagram, which of the following provides the best interpretation of the multiplicities for the association between the employees and purchases classes?

A single purchase can be made by a combination of several employees.

An employee can make a maximum of one purchase.

Each purchase must be made by one employee.

Each product should be received by an employee.

 

 

42.  In the following diagram, which of the following provides the best interpretation of the multiplicities for the association between the cash disbursements and employees classes?

A cash disbursement must be made by the employee who made the purchase.

A cash disbursement can be made by a combination of several employees.

An employee can make a maximum of one cash disbursement.

Each cash disbursement must be made by one employee.

 

 

43.  Which of the following best describes a type image?

A description attached to a UML association when there are multiple associations between classes.

A UML class added to collect management information, such as category.

A BPMN activity that allows a business process to branch based on type.

A description attached to a BPMN gateway that clarifies the nature of the gateway.

 

 

44.  Which of the following would likely be a primary key in a purchases table?

Purchase_Order_Date.

Purchase_Order_Number.

Supplier_Number.

Product_Description.

 

45. A well controlled purchases and payments process would likely have which of the following roles seperated into swimlanes?

Accounts Payable, Receiving & Buyer.Correct
Supplier, Receiving & Buyer.
Supplier, Accounts Payable & Receiving.
Accounts Payable, Receiving & Shipping.