Accounting Information Systems - Exam Flashcards

Flashcards covering various topics from the lecture notes for exam preparation.

What type of data model allows each record to have multiple parent and child records?

The network model.

Which rule states that the data value for a foreign key could be null?

Referential Integrity Rule

Which of the following tasks cannot be performed through queries in Access?

Create and update relationships.

In Microsoft Access, what is the primary use of tables in a database?

Data storage.

Which system integrates all functional areas within an organization for information exchange?

An enterprise resource planning system.

What advantage does an enterprise resource planning system have over multiple independent functional systems?

Increased responsiveness and flexibility while aiding in the decision-making process.

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

The relational model.

What property should the primary key in a table in Microsoft Access be set to?

The Required field = "Yes", the Indexed field = "Yes (No Duplicates)".

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

Forms

Which of the following is not a likely module of an Enterprise Reporting System (ERP)?

Cloud based computing.

Which statement about the requirements of table design is incorrect?

All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key.

To convert a conceptual model with a maximum Multiplicities relationship of 'many to many' into relationship database tables, one must:

Create a relationship table to handle the many-to-many relationship.

Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales?

Cash Collection (1..1) – Sale (1..1).

A Query in a program language such as Structured Query Language (SQL) can be used to

Update data, Report data, and Retrieve data.

In Microsoft Access, we use Forms for:

Data entry.

The most likely user of a Microsoft Access Report:

Store manager.

Which of the following is not a type of data model?

Normalization data model.

What kind of data model has the greatest ability to scale?

Relational data model.

Which of the following about cloud computing is incorrect?

Data stored in a cloud computing system is always secure.

What is the main purpose of using foreign keys in a relational database design?

It is used to link tables.

Which of the following about SQL is incorrect?

SQL uses the PIVOT function to insert data.

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

Cash.

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

Cash collection.

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

Purchasing manager.

Which of the following is not accurate regarding tables?

Records represent attributes of a table.

Which of the following is not one of the advantages relational data models have over other data models?

Exclusively uses parent/child relationships.

Which of the following best describes a DBMS?

Software that can create, modify and query databases.

Classes in a relational database model for AISs are typically grouped into all of the following categories except:

Activities.

Which of the following items does not represent a UML class diagram object and its resulting database object?

Multiplicities → Records.

A foreign key in a database table is always:

A primary key in a related table.

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

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

Which of the following is not one of the objects used in Microsoft Access?

Sites.

Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers?

Reports.

Which set of multiplicities correctly shows the relationship between the Cash Receipts table and the Sale table for an organization that allows customers to buy on credit and pay in multiple installments?

Cash Receipts (0..N) – Sale (1..1).

Which of the following operators would be used in a SQL query designed to simply display database records?

SELECT.

Consider the following SQL query. Which item best describes the results of the query? SELECT VendorID, Sum(POTotal) FROM [Purchase Orders] GROUP BY VendorID

Displays the vendor ID and the sum of all purchase order totals for that vendor.

Using the following table what will result from the SQL command “SELECT Item SKU, Price”? Item SKU Price Manufacturer 651 $ 5.00 Nike 546 $ 4.00 Nike 876 $ 5.00 Under Armour 165 $ 10.00 Addidas

All rows but only the 1st and 2nd column.

Using the following table what will result from the SQL command “SELECT *, WHERE [Price] = $5”? Item SKU Price Manufacturer 651 $ 5.00 Nike 546 $ 4.00 Nike 876 $ 5.00 Under Armour 165 $ 10.00 Addidas

All columns, rows 1 and 3.

ERPs are useful to auditors for which of the following reasons?

ERPs track details regarding creation, modification, and use of transactions throughout the organization in a single system.

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

Installing the ERP software.

Which of the following best describes cloud computing?

Internet based computing where shared resources, software and information are provided to firms on demand.

Which of the following means a row in a database environment?

Record

Which of the following is not an entity in an REA data model?

All of the answers are entities in REA models.

Which item below would not be considered an entity?

A customer address

Which item below would not be considered an attribute?

A bank

Select the best answer to describe a business situation such as Purchases (1..1) – (1..*) Cash Disbursement.

The company may pay partial for a purchase transaction.

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

Contain a series of activities that are hidden from view.

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

Illustrate process flow when an exception occurs.

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

Access controls limit who can change records and application controls ensure data integrity.

Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Quote class and the Order class?

Each quote may result in many future Orders.

Refer to the following diagram. Which of the following answers provides the best interpretation of the multiplicities for the association between the Order class and the Products class?

An order may include many products.

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.

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

Some orders result in several payments from the customers.

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 Product Categories classes?

Each product category has one manager.

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?

Several employees participate in each sale.

Refer to the following diagram. Which of the following answers does not provide a valid interpretation of the multiplicities for the association between the Inventory and the Product Category classes?

Every product category includes at least one inventory item.

Which of the following business activities are not part of the sales and collection process?

Accounts payable

Which of the following accounting transactions would you expect in the sales and collection process?

Debit cost of goods sold and credit inventory

Which of the following is the first step in implementing a relational database from a UML class diagram for the sales and collection process?

Review the table and attribute definitions.

Which of the following is not part of the process to implement a relational database from a UML class diagram of the sales and collection process?

Set the associations between classes

Many companies record both purchase orders and purchases; when would such a company generally recognize the purchase?

When the products are received from the supplier and accepted.

In a BPMN collaboration model of the purchase process, one pool describes the focal organization's activities and the other pool describes what?

The supplier's activities

In a BPMN collaboration model of the purchase process, which of the following is the appropriate term for the message flows between pools?

Choreography

In a BPMN collaboration model of the purchase process, which of the following best describes the purpose of swimlanes?

Showing different departments involved in the purchase process

In a BPMN activity diagram, which of the following best describes the purpose of an intermediate timer event?

All of these choices are correct

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

Ensure suppliers are satisfied

Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Purchases and Cash Disbursements classes?

Disbursements are made after the purchases are recorded

Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Purchases and Products classes?

Each purchase can include many products

Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Employees and Supplier Categories classes?

Each employee can be assigned to manage many supplier categories

Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Product Categories and Supplier Categories classes?

Some employees may manage several product categories, and some employees may manage several supplier categories, but there is no direct link between supplier and product categories.

Which of the following activities is not associated with the purchase and payments business process?

Selling products and services

The purchase is generally recorded in the financial statements when which of the following activities takes place?

Receive items.

A BPMN activity diagram that contains two blank pools would typically be created in order to highlight which of the following?

The choreography of the business process.

When documenting a purchases and payments business process, which of the following BPMN activity diagram symbols should be used to indicate that accounts payable waits until the end of the month to pay vendors?

Intermediate timer event.

Which of the following is not an application control when placing a purchase order?

System provided type image.

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

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

Which of the following is an example of an application control for the purchases and payments business process?

The purchase order number is automatically assigned.

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

Each purchase must be made by one employee.

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?

Each cash disbursement must be made by one employee.

In the following diagram, which of the following provides the best interpretation of the multiplicities for the association between the employees and product categories classes?

Each product category may be managed by several employees.

Which of the following best describes a type image?

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

Which of the following would likely be a foreign key in a purchases table?

Supplier_Number.

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

PurchaseOrderNumber.

Which of the following two tables would likely result in a many-to-many relationship in a purchases and payments class diagram?

Purchase Order and Products.

The following diagram would result in a database with how many tables?

10.

Which of the following general ledger accounts would likely not be impacted in a purchases and payments process?

Accounts Receivable.

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

Request prices and availability→Place Purchase Order→Receive Items→Send Payment.

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

Accounts Payable, Receiving & Buyer.

In general, the goal of information security management is to protect all of the following except:

Redundancy.

Which of the following statements is incorrect about digital signatures?

A digital signature is a message digest encrypted using the document creator's public key.

What is the primary objective of data security controls?

B) To ensure that data storage media are subject to authorization prior to access, change, or destruction.

An entity doing business on the internet most likely could use any of the following methods to prevent unauthorized intruders from accessing proprietary information except:

Batch processing.

When client's accounts payable computer system was relocated, the administrator provided support through a dial-up connection to server. Subsequently, the administrator left the company. No changes were made to the accounts payable system at that time. Which of the following situations represents the greatest security risk?

User accounts are not removed upon termination of employees.

An information technology director collected the names and locations of key vendors, current hardware configuration, names of team members, and an alternative processing location. What is the director most likely preparing?

Disaster recovery plan.

Bacchus, Incorporated is a large multinational corporation with various business units around the world. After a fire destroyed the corporation headquarters and largest manufacturing site, plans for which of the following would help Bacchus ensure a timely recovery?

Business continuity.

SOC 1 reports are not designed to be used by

General public.

SOC 2 reports are not designed to be used by

General public.

SOC 3 reports are designed to be used by

General public.

Which of the following statements is correct about SOC reports?

The purpose of SOC 3 report is to provide a general understanding and for marketing purposes of a service company.

Which of the following statements is correct about SOC reports?

The contents of SOC 1 report is on the service provider’s internal controls relevant to the user company’s financial reporting.