Exam 4: Relational Databases and Enterprise System

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.

Each attribute in a table can have several names.

What is the main purpose of using foreign keys in a relational database design? A. It provides useful financial data value in the table. B. It is required in all tables. C. It is used to link tables. D. None of the above is correct.

Which of the following tasks cannot be performed through queries in Access? A. Retrieve and display data B. Calculations of data C. Data sorting D. Create and update relationships

Which of the following is considered one of the primary benefits of ERPs? A. ERPs allow an organization to integrate information related to multiple business functions (i.e., manufacturing, human resources, finance, etc.). B. ERPs all operate using cloud computing technology. C. ERPs create protected data silos for each function in the organization. D. ERPs use relational data models, which are required by the Sarbanes-Oxley Act of 2002

While hierarchical and network data models require relationships to be formed at the database creation, relational data models allow relationships to be created and updated as needed.

Which of the following items can best be described as an "Agent" in the REA data model? A. Purchases. B. Accounts payable clerk. C. Raw material inventory. D. None of the above is correct.

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

To convert a conceptual model with a maximum multiplicities relationship of "many to many" into relationship database tables, one must 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.

Which of the following is not one of the advantages relational data models have over other data models? A. Exclusively uses parent/child relationships B. Increased flexibility and scalability C. Simplicity D. Reduced information redundancy

Which of the following best describes a DBMS? A. The manager(s) in charge of a company's databases B. Software that can create, modify and query databases C. A language used to retrieve data from databases D. A database created using Microsoft software

Which of the following is not a potential disadvantage of using cloud computing to host an organization's ERP? A. Uncertainty about the data security of sensitive information hosted offsite B. Reduced internal processing and storage needs for the organization C. Uncertainty about the adequacy of the host's processing speed and availability D. Requires a reliable Internet connection

The SQL command "Group by" can be used to order an amount in a descending order.

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations. Which of the following systems is most effective for this application? A. A decision support system. B. An executive support system. C. An office automation system. D. An enterprise resource planning system.

The asterisk (*) following the SELECT SQL statement is a wild card indicating all columns should be selected.

Three types of data models used today are: the hierarchical model, the network model and the relational model.

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

Access is a simple database management system that can be used to run databases for individuals and small firms.

Which of the following about SQL is incorrect? 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 is very user-friendly. D. SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query.

Classes could be grouped into Resources (R), Entities (E), and Assets (A) in data modeling.