Question 1

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

Accepted Answer

A) Tables. 
B) Sites. 
C) Forms. 
D) Macros. 
A) Tables. 
B) Sites. 
C) Forms. 
D) Macros. B

Question 2

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. 
A) Cash. 
B) Cashier. 
C) Cash collection. 
D) Customer. C

Question 3

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. 
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. B

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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. 
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.

Question 6

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. 
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.

Question 7

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. 
A) Retrieve and display data. 
B) Calculations of data. 
C) Data sorting. 
D) Create and update relationships.

Question 8

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. 
A) Events. 
B) Agents. 
C) Resources. 
D) Activities.

Question 9

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. 
A) Update data. 
B) Report data. 
C) Retrieve data. 
D) All of the choices are correct.

Question 10

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. 
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.

Question 11

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. 
A) Classes → Tables. 
B) Attributes → Fields. 
C) Multiplicities → Records. 
D) Associations → Relationships.

Question 12

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. 
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.

Question 13

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. 
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.

Question 14

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. 
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.

Question 15

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). 
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).

Question 16

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). 
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).

Question 17

In Access,users can edit database information in reports.

Accepted Answer

A) True 
 B)False

Question 18

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. 
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.

Question 19

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. 
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.

Question 20

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). 
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).

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

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

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

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

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

Which of the following correctly describes the Referential Integrity Rule?

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

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

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

Which of the following about SQL is incorrect?

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

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

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

A foreign key in a database table is always:

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

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?

In Access,users can edit database information in reports.

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

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

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

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters

Exam 4: Relational Databases and Enterprise Systems

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

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

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

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

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

Which of the following correctly describes the Referential Integrity Rule?

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

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

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

Which of the following about SQL is incorrect?

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

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

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

A foreign key in a database table is always:

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

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?

In Access,users can edit database information in reports.

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

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

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

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters