ACCY EXAM 2 QUESTIONS AND
ANSWERS
Which of the following are basic elements of Sunset Graphics' process for preparing
quotes?
Multiple select question.
Prices and quantities
Sunset's products and services
Customer's requirements
Payment in advance - Answer- Prices and quantities
Sunset's products and services
Customer's requirements
Range checks are designed to ensure that data entries are between established lower
and [BLANKS] bounds. - Answer- upper
True or false: Type images help manage business processes by applying constraints or
summarizing economic activity. - Answer- true
The difference between business rules and internal control is that business rules
[BLANK] internal control activities. - Answer- implement
Which of the following is the best reason that type images support internal control
activities?
Multiple choice question.
Designate responsibilities for separation of duties
Assign customers to specific employees
Differentiate between internal and external agents
Establish business rules for the process - Answer- Designate responsibilities for
separation of duties
Which of the following classes is most likely to be a type image?
Multiple choice question.
, Inventory
Job category
Orders
Employee - Answer- job category
The difference between business rules and internal control is that business rules
[BLANK] internal control activities. - Answer- implement
Determining proper foreign key placement uses [BLANK] - Answer- multiplicities
Type images support [BLANK] activities by designating responsibilities. - Answer-
control
True or false: Type images help manage business processes by applying constraints or
summarizing economic activity. - Answer- true
In a [BLANK] to [BLANK] relationship (where the maximum is many on both sides of the
association), the link is implemented by creating a new, linking table where the primary
key is the combination of the two primary keys of the participating tables. - Answer-
many to many
The primary key of the Order Items table is the [BLANK] of primary key of the Order
table (order num) and the primary key of the Products table (prod num). - Answer-
combination
Which of the following are rules for forming appropriate relational tables from a UML
class diagram?
Multiple select question.
Add a table for each many-to-many relationship.
Add a table for each class.
Add extra tables for access control.
Add a table for each association. - Answer- Add a table for each many-to-many
relationship.
Add a table for each class.
To turn a many-to-many relationship into a one-to-many relationship, you will create a
[BLANK] association between the tables. - Answer- composition
Which of the following would be found in the Order Items table describing the specific
products sold on each order?
Multiple select question.
The quantity of each product to be sold on that order
The date that the Order was issued
ANSWERS
Which of the following are basic elements of Sunset Graphics' process for preparing
quotes?
Multiple select question.
Prices and quantities
Sunset's products and services
Customer's requirements
Payment in advance - Answer- Prices and quantities
Sunset's products and services
Customer's requirements
Range checks are designed to ensure that data entries are between established lower
and [BLANKS] bounds. - Answer- upper
True or false: Type images help manage business processes by applying constraints or
summarizing economic activity. - Answer- true
The difference between business rules and internal control is that business rules
[BLANK] internal control activities. - Answer- implement
Which of the following is the best reason that type images support internal control
activities?
Multiple choice question.
Designate responsibilities for separation of duties
Assign customers to specific employees
Differentiate between internal and external agents
Establish business rules for the process - Answer- Designate responsibilities for
separation of duties
Which of the following classes is most likely to be a type image?
Multiple choice question.
, Inventory
Job category
Orders
Employee - Answer- job category
The difference between business rules and internal control is that business rules
[BLANK] internal control activities. - Answer- implement
Determining proper foreign key placement uses [BLANK] - Answer- multiplicities
Type images support [BLANK] activities by designating responsibilities. - Answer-
control
True or false: Type images help manage business processes by applying constraints or
summarizing economic activity. - Answer- true
In a [BLANK] to [BLANK] relationship (where the maximum is many on both sides of the
association), the link is implemented by creating a new, linking table where the primary
key is the combination of the two primary keys of the participating tables. - Answer-
many to many
The primary key of the Order Items table is the [BLANK] of primary key of the Order
table (order num) and the primary key of the Products table (prod num). - Answer-
combination
Which of the following are rules for forming appropriate relational tables from a UML
class diagram?
Multiple select question.
Add a table for each many-to-many relationship.
Add a table for each class.
Add extra tables for access control.
Add a table for each association. - Answer- Add a table for each many-to-many
relationship.
Add a table for each class.
To turn a many-to-many relationship into a one-to-many relationship, you will create a
[BLANK] association between the tables. - Answer- composition
Which of the following would be found in the Order Items table describing the specific
products sold on each order?
Multiple select question.
The quantity of each product to be sold on that order
The date that the Order was issued
