AIS EXAM 2 CERTIFICATION EVALUATION 2026 COMPLETE QUESTIONS AND SOLUTIONS UPDATED

AIS EXAM 2 CERTIFICATION EVALUATION
2026 COMPLETE QUESTIONS AND
SOLUTIONS UPDATED

◉ Which of the following attributes in the Cash Receipts table
[representing payments received from customers] would most likely
be a foreign key?


customer check number
customer number
cash receipt date
cash receipt number
Answer: customer number


◉ An entity is anything about which the organization wishes to
capture data.
Answer: True


◉ Which of the following is least likely to be an attribute of an
employee table in a normalized database?


Employee address

,All of these would be attributes of the employee table in a
normalized database.


Employee supervisor's name


Employee number


Employee name
Answer: All of these would be attributes of the employee table in a
normalized database.


◉ The most important feature of a DBMS is to permit authorized
user access to the database.
Answer: True


◉ Accountants have no real reason to care about databases.
Answer: False


◉ Tuples are database records.
Answer: True

, ◉ Normalizing your database puts it at risk to the three database
anomalies.
Answer: False


◉ Primary keys are the characteristics that uniquely identify each
record in a table.
Answer: True


◉ Accounts Receivable would appear in an REA diagram as an
example of which kind of entity?


resource
event
agent
none of the above
Answer: none of the above


◉ Which of the following is NOT likely to be depicted as an entity in
the REA data model?


customers
sales
invoices