Question 1

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

Accepted Answer

A)  Events.
B)  Agents.
C)  Resources.
D)  Activities.E) A) and B)
F) None of the above

Question 2

Which of the following correctly describes the Referential Integrity Rule?

Accepted Answer

A)  The primary key of a table must have data values (cannot be null) .
B)  Each attribute in a table must have a unique name.
C)  The data value for a foreign key could be null.
D)  Values of a specific attribute must be of the same type.E) B) and D)
F) C) and D)

Question 3

An enterprise resource planning system has which of the following advantages over multiple independent functional systems?

Accepted Answer

A)  Modifications can be made to each module without affecting other modules.
B)  Increased responsiveness and flexibility while aiding in the decision-making process.
C)  Increased amount of data redundancy since more than one module contains the same information.
D)  Data can be accessed through Structured Query Language (SQL) .E) A) and D)
F) A) and B)

Question 4

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

Accepted Answer

A)  ERPs use cloud computing technology,which allows auditors to review transactions from anywhere.
B)  ERPs track details regarding creation,modification,and use of transactions throughout the organization in a single system.
C)  ERPs are required by the Sarbanes-Oxley Act of 2002.
D)  ERPs are spread across multiple logical databases,allowing auditors to minimize disruption to processing when reviewing ERP activity.E) A) and D)
F) C) and D) B

Question 5

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

Accepted Answer

A)  Tables.
B)  Sites.
C)  Forms.
D)  Macros.E) None of the above
F) A) and D) B

Question 6

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?

Accepted Answer

A)  Cash Receipts (1..1) - Sale (1..1) .
B)  Cash Receipts (1..N) - Sale (0..N) .
C)  Cash Receipts (1..1) - Sale (N..M) .
D)  Cash Receipts (0..N) - Sale (1..1) .E) B) and C)
F) None of the above

Question 7

A foreign key in a database table is always:

Accepted Answer

A)  A unique identifier for a record in that table.
B)  A numeric field.
C)  The name of a UML class.
D)  A primary key in a related table.E) A) and D)
F) None of the above

Question 8

In a hierarchical data model,data elements are related in many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 9

In Access,users can edit database information in reports.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  Classes → Tables.
B)  Attributes → Fields.
C)  Multiplicities → Records.
D)  Associations → Relationships.E) A) and D)
F) All of the above

Question 11

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

Accepted Answer

A)  Integrating with external business partners' information systems.
B)  Converting data from legacy systems to the ERP.
C)  Installing the ERP software.
D)  Successfully completing a large project in an organization.E) B) and D)
F) None of the above

Question 12

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

Accepted Answer

A)  Update data.
B)  Report data.
C)  Retrieve data.
D)  All of the choices are correct.E) C) and D)
F) A) and C)

Question 13

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

Accepted Answer

A)  Cash Collection (1..1) - Sale (1..N) .
B)  Cash Collection (1..N) - Sale (1..N) .
C)  Cash Collection (1..N) - Sale (1..1) .
D)  Cash Collection (1..1) - Sale (1..1) .E) None of the above
F) A) and D)

Question 14

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

Accepted Answer

A)  Retrieve and display data.
B)  Calculations of data.
C)  Data sorting.
D)  Create and update relationships.E) All of the above
F) A) and C)

Question 15

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

Accepted Answer

A)  Displays all purchase order lines for all vendors.
B)  Adds new purchase order information to the purchase orders table.
C)  Displays the vendor ID and all purchase order totals in the purchase orders table.
D)  Displays the vendor ID and the sum of all purchase order totals for that vendor.E) B) and C)
F) A) and D)

Question 16

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

Accepted Answer

A)  Create a foreign key in one of the tables to link the two tables.
B)  Create a relation with no attributes of its own.
C)  Create a relationship table to handle the many-to-many relationship.
D)  Many-to-many relationship cannot be represented in Access.E) C) and D)
F) A) and D)

Question 17

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

Accepted Answer

A)  A database entity must fit within the REA model.
B)  A record's foreign key value must be null.
C)  A record's primary key must have a data value.
D)  All values of an attribute must be of the same data type.E) A) and D)
F) C) and D)

Question 18

Which of the following statements about the requirements of table design is incorrect?

Accepted Answer

A)  Each attribute in a table must have a unique name.
B)  Values of a specific attribute must be of the same type.
C)  Each attribute (column) of a record (row) must be single-valued.
D)  All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key.E) None of the above
F) A) and D)

Question 19

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

Accepted Answer

A)  Cash.
B)  Cashier.
C)  Cash collection.
D)  Customer.E) A) and D)
F) None of the above C

Question 20

Which of the following about SQL is incorrect?

Accepted Answer

A)  SQL is a language designed to query data in a relational database.
B)  SQL is based on relational algebra and allows a user to query and update the database.
C)  SQL uses the PIVOT function to insert data.
D)  SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query.E) A) and C)
F) All of the above

Exam 4: Relational Databases and Enterprise Systems

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

Correct AnswerverifiedShow Answer

Which of the following correctly describes the Referential Integrity Rule?

Correct AnswerverifiedShow Answer

An enterprise resource planning system has which of the following advantages over multiple independent functional systems?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedB

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?

Correct AnswerverifiedShow Answer

A foreign key in a database table is always:

Correct AnswerverifiedShow Answer

In a hierarchical data model,data elements are related in many-to-many relationships.

Correct AnswerverifiedShow Answer

In Access,users can edit database information in reports.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following statements about the requirements of table design is incorrect?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

Which of the following about SQL is incorrect?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified