Exam 2

Question 1

What is a record?

Answer 1

A related group of fields (a row)

Question 2

What is an attirbute?

Answer 2

A column

Question 3

What is a field?

Answer 3

A specific attribute of interest; where the row and attribute meet

Question 4

What is a primary key?

Answer 4

A database attribute that uniquely identifies a specific row in a table

Question 5

What is a foreign key?

Answer 5

An attribute in one table that is also a primary key in another and is used to link two tables

Question 6

Explain a one-to-one relationship

Answer 6

Where one record of the 1st table is to one record of another table.

Question 7

Explain a one-to-many relationship

Answer 7

A single record from one table can be linked to zero or more rows in another table.

Question 8

Explain a many-to-many relartionship

Answer 8

lets you relate each row in one table to many rows in another table and vice versa.

Question 9

What are the 4 types of data analytics?

Answer 9

Descriptive analytics (what happened?)
Diagnostics analytics (why did this happen?)
Predictive analytics (what might happen in the future?)
Prescriptive analytics (what should be done?)

Question 10

What is the difference between preventive, detective, and corrective controls?

Answer 10

Preventive - stop it before it happens
Detective - Discover it after it happens
Corrective - controls to fix problems

Question 11

What is ARC and what does it attempt to stop?

Answer 11

ARC is the segregation of duties. It attempts to separate authorization, recording, and custody.

Question 12

What was the role of SOX in the establishment of internal control?

Answer 12

Public companies are required to have it. CFO and CEO
SOX Act requires companies to implement and maintain internal controls over financial reporting

Question 13

What is the primary difference between the COBIT and COSO (one big thing separates the two)?

Answer 13

COBIT control is focused towards IT, while COSO control is focused on accounting.

Question 14

What does CRIME stand for?

Answer 14

Control Environment
Risk Assessment
Information and Communication
Monitoring
Existing Control Activities

Question 15

What are the basic differences between inherent risk and control risk?

Answer 15

Inherent risk - existing risk before we stop it (it varies, some things are inherently riskier than others)
Control risk - risk after you control it. never be zero, always have some risk

Question 16

What are CRM systems?

Answer 16

Customer relationship management is how might a customer interact with an AIS.

Question 17

Why is fraud so prevalent in the revenue cycle?

Answer 17

Misrepresentation or revenue and theft of cash (explain in detail)

Question 18

Why is fraud so prevalent in the expenditure cycle?

Answer 18

Cash (explain in detail)