ACC 409 FINAL (QUIZZES) EXAM QUESTIONS AND ANSWERS
WITH COMPLETE SOLUTIONS GRADED A++
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 and provide an audit trail of any changes.
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.
Business models provide value in all of the following areas except which one?
Employee performance appraisal.
A company would like to implement a management information system that
integrates all functional areas within an organization to allow information
exchange and collaboration among all parties involved in business operations.
Which of the following systems is most effective for this application?
An enterprise resource planning system.
Which of the following least reflects the purpose of a business rule in the
purchase process?
Ensure suppliers are satisfied
Which of the following is not a criterion for selection of a primary key?
, The primary key should always be numeric.
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.
Activity based costing is an example of:
Discretionary information.
A BPMN process flow can start in one pool and end in the collaborating pool.
False
Consider the non-profit organization Doctors without Borders (Médecins Sans
Frontières., a Nobel Peace Prize winning organization that provides medical
services in war zones and developing countries. For this type of organization,
which of the following would likely be the best measure of business value?
Lives saved.
Consider an association between a Pet Owners class and a Pets class in a Unified
Modeling Language (UML. Class diagram. The multiplicities next to the Pet
Owners class are 1..1 and the multiplicities next to the Pets class are 1..*. Which
of the following is the best way to implement that association in your database?
Post the primary key of Pet Owners as a foreign key in Pets.
Which of the following is an example of information as opposed to just data:
Dress sales in Michigan at Walmart Store #3458.
Which of the following is not something a business rule would implement?
Notifications
WITH COMPLETE SOLUTIONS GRADED A++
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 and provide an audit trail of any changes.
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.
Business models provide value in all of the following areas except which one?
Employee performance appraisal.
A company would like to implement a management information system that
integrates all functional areas within an organization to allow information
exchange and collaboration among all parties involved in business operations.
Which of the following systems is most effective for this application?
An enterprise resource planning system.
Which of the following least reflects the purpose of a business rule in the
purchase process?
Ensure suppliers are satisfied
Which of the following is not a criterion for selection of a primary key?
, The primary key should always be numeric.
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.
Activity based costing is an example of:
Discretionary information.
A BPMN process flow can start in one pool and end in the collaborating pool.
False
Consider the non-profit organization Doctors without Borders (Médecins Sans
Frontières., a Nobel Peace Prize winning organization that provides medical
services in war zones and developing countries. For this type of organization,
which of the following would likely be the best measure of business value?
Lives saved.
Consider an association between a Pet Owners class and a Pets class in a Unified
Modeling Language (UML. Class diagram. The multiplicities next to the Pet
Owners class are 1..1 and the multiplicities next to the Pets class are 1..*. Which
of the following is the best way to implement that association in your database?
Post the primary key of Pet Owners as a foreign key in Pets.
Which of the following is an example of information as opposed to just data:
Dress sales in Michigan at Walmart Store #3458.
Which of the following is not something a business rule would implement?
Notifications
