Question 1

Using the following table what will result from the SQL command "SELECT Item SKU,Price"? 
A)All rows but only the 1st and 2nd column.
B)All rows but only columns with numerical data.
C)All data in the 1st and 2nd columns for the first and last row.
D)All data in the table.

Accepted Answer

The SQL command "SELECT Item SKU,Price" will only select the data from the first and second column of every row in the table.

Question 2

Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers?
A)Tables.
B)Reports.
C)Forms.
D)Macros.

Accepted Answer

Reports in Microsoft Access are used to integrate data from one or more queries and/or tables in order to present information useful to decision makers. Tables store data, forms provide a user interface for data entry/editing, and macros automate tasks within Access.

Question 3

Which of the following is not one of the objects used in Microsoft Access?
A)Tables.
B)Sites.
C)Forms.
D)Macros.

Accepted Answer

The objects used in Microsoft Access are tables, forms, queries, reports, macros, and modules. "Sites" is not an object in Microsoft Access.

Question 4

Which of the following is not one of the typical challenges organizations face when implementing an ERP?
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.

Accepted Answer

Installing the ERP software is one of the typical challenges organizations face when implementing an ERP. Therefore, it is not the correct answer. The other options (integrating with external business partners' information systems, converting data from legacy systems to the ERP, and successfully completing a large project in an organization) are common challenges faced during ERP implementation.

Question 5

Classes in a relational database model for AISs are typically grouped into all of the following categories except:
A)Events.
B)Agents.
C)Resources.
D)Activities.

Accepted Answer

The four main categories of classes in a relational database model for AISs are events, agents, resources, and activities. There is no fifth category, so choice D is incorrect.

Question 6

Consider the following SQL query.Which item best describes the results of the query?SELECT VendorID,Sum(POTotal)FROM [Purchase Orders]GROUP BY VendorID
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.

Accepted Answer

The query selects the VendorID and calculates the sum of POTotal for each vendor by grouping them based on their VendorID. Therefore, the result of the query will display the vendor ID and the sum of all purchase order totals for that vendor.

Question 7

Which of the following operators would be used in a SQL query designed to simply display database records?
A)SELECT.
B)INSERT.
C)DISPLAY.
D)VIEW.

Accepted Answer

The SELECT operator is used to retrieve data from a database and is commonly used to display database records. INSERT is used to add new records to a table, DISPLAY is not a valid SQL operator, and VIEW is used to create a virtual table based on a SELECT statement.

Question 8

Which of the following items does not represent a UML class diagram object and its resulting database object?
A)Classes → Tables.
B)Attributes → Fields.
C)Multiplicities → Records.
D)Associations → Relationships.

Accepted Answer

Multiplicities represent the cardinality between classes, they do not represent database records.

Question 9

Which of the following statements best describes the entity integrity rule?
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.

Accepted Answer

The entity integrity rule states that a record's primary key must have a data value. This means that every record in a table must have a unique identifier, and that identifier cannot be null.

Question 10

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

Accepted Answer

In this scenario, a single sale can result in multiple cash receipts because customers can pay in multiple installments. However, each cash receipt is linked to exactly one sale. Therefore, for the Sale table, each sale can have multiple associated cash receipts (0..N), indicating that there might be sales not yet paid for. For the Cash Receipts table, each receipt is associated with exactly one sale (1..1), reflecting that every payment is for a specific sale.

Question 11

ERPs are useful to auditors for which of the following reasons?
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.

Accepted Answer

ERPs are useful to auditors because they track details regarding creation, modification, and use of transactions throughout the organization in a single system, which enables auditors to gain visibility into transactional activity across the organization. This can help auditors detect fraud, errors, and other irregularities, and ensure compliance with relevant laws and regulations. Cloud computing technology (A) may make it easier for auditors to access data from ERPs, but it is not the primary reason why ERPs are useful to auditors. While the Sarbanes-Oxley Act of 2002 (C) requires companies to maintain effective internal controls over financial reporting, it does not specifically require the use of ERPs. Finally, while some ERPs may be spread across multiple logical databases (D), this is not a primary reason why ERPs are useful to auditors.

Question 12

Using the following table what will result from the SQL command "SELECT *,WHERE [Price] = $5"? 
A)All columns,row 1.
B)Price column,row 1.
C)All columns,rows 1 & 3.
D)Price column,row 3.

Accepted Answer

The SQL command "SELECT *,WHERE [Price] = $5" means that we want to select all columns where the price is equal to $5. Only rows 1 and 3 have a price of $5, so the query will return all columns in rows 1 and 3.

Question 13

Which of the following best describes cloud computing?
A)Internet based computing where an ERP system is shared amongst multiple firms.
B)Internet based computing where shared resources,software and information are provided to firms on demand.
C)Internet based software which is used to run SQL queries.
D)Internet based software that helps monitor the security of a firm's resources.

Accepted Answer

Cloud computing refers to the delivery of on-demand computing services, including software, storage, and processing power, over the internet. These resources can be shared among multiple users and accessed anytime from anywhere. Option A is incorrect because an ERP system is not necessarily shared amongst multiple firms in cloud computing. Option C refers to a specific type of software and is not a complete definition of cloud computing. Option D is incorrect because while cloud computing can help with security, it is not its primary function.

Question 14

A foreign key in a database table is always:
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.

Accepted Answer

A foreign key is a field in a table that refers to the primary key of another table. It is used to establish a relationship between two tables in a database. Therefore, a foreign key is not a unique identifier for a record in that table and it is not necessarily a numeric field. The name of a UML class is also unrelated to the concept of a foreign key.

Quiz 4: Relational Databases and Enterprise Systems

Using the following table what will result from the SQL command "SELECT Item SKU,Price"?

Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers?

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

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

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

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 operators would be used in a SQL query designed to simply display database records?

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

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

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?

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

Using the following table what will result from the SQL command "SELECT *,WHERE [Price] = $5"?

Which of the following best describes cloud computing?

A foreign key in a database table is always: