Deck 4: Relational Databases and Enterprise Systems

Question 1

In Microsoft Access,we use tables in a database for:

A)Data entry.
B)Data storage.
C)Data retrieval.
D)Two of these choices are correct.

Answer 1

B

Question 2

Access offers modules,which are defined by users to automate processes like opening a specific form.

Answer 2

False

Question 3

Queries in Access are utilized by users to enter data into tables and view existing records.

Answer 3

False

Question 4

Which type of data models allows each record to have multiple parent and child records?

A)The hierarchical mode.
B)The network model.
C)The relational model.
D)None of these choices is correct.

Question 5

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

Question 6

Cloud computing is an internet-based computing where shared resources,software,and information is provided to firms on demand.

Question 7

In Access,users can edit database information in reports.

Question 8

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

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

Question 9

SQL is based on relational algebra and allows a user to query and update the database.

Question 10

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.

Question 11

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

Question 12

Which of the following correctly describes the Referential Integrity Rule?

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 13

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

Question 14

Each attribute in a table can have several names.

Question 15

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

Question 16

What kind data model is most commonly used as a basis for today's enterprise systems?

A)The hierarchical mode.
B)The network model.
C)The relational model.
D)None of these choices is correct.

Question 17

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.

Question 18

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)A Structured Data system.
C)A Microsoft database.
D)An enterprise resource planning system.

Question 19

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

Question 20

The "Where" SQL clause can be used to link two tables.

Question 21

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

A)Cashier.
B)Sales.
C)Cash.
D)Two of the above are correct.

Question 22

Which of the following is not a type of data model?

A)Hierarchical data model.
B)Network data model.
C)Normalization data model.
D)Relational data model.

Question 23

What kind of data model has the greatest ability to scale?

A)Hierarchical data model.
B)Network data model.
C)Relational data model.
D)All of the choices are correct.

Question 24

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

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

Question 25

The most likely user of a Microsoft Access Report:

A)Data input clerk.
B)Store manager.
C)Systems analyst.
D)System coder.

Question 26

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.

Question 27

In Microsoft Access,we use "Forms" for:

A)Data entry.
B)Data storage.
C)Date retrieve.
D)Two of the choices are correct.

Question 28

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

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 29

Which of the following about cloud computing is incorrect?

A)Cloud computing is Internet-based computing where shared resources,software,and information are provided to firms on demand.
B)Cloud computing can easily host enterprise system applications.
C)If the internet connection goes down the system will not function.
D)Data stored in a cloud computing system is always secure.

Question 30

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.

Question 31

Which of the following is not a likely module of an Enterprise Reporting System (ERP)?

A)Financial Accounting.
B)Cloud based computing.
C)Payroll.
D)Sales and Distribution.

Question 32

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

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 33

Which of the following is not a construct in a relational database?

A)Tables
B)Attributes
C)Records
D)Forms

Question 34

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.

Question 35

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)It is required for forms.

Question 36

Which of the following is not accurate?

A)Columns in a table are called fields.
B)Fields represent attributes of a class.
C)Records represent attributes of a table.
D)Rows in a table are called records.

Question 37

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

A)Purchases.
B)Purchasing manager.
C)Raw material inventory.
D)Purchase returns.

Question 38

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

The property of the primary key in a table in Microsoft Access should be set to:

A)The Required field = "Yes",the Indexed field = "Yes (No Duplicates)".
B)The Required field = "NO" and the Indexed field = "Yes (No Duplicates)".
C)The Required field = "Yes" and the Indexed field = "Yes (Duplicated)".
D)The Required field = "NO" and the Indexed field = "Yes (Duplicated)".

Question 40

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

A)Cash.
B)Cashier.
C)Cash collection.
D)Customer.

Question 41

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.

Question 42

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.

Question 43

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

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

Question 44

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.

Question 45

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.

Question 46

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.

Question 47

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.

Question 48

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.

Question 49

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.

Question 50

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

Question 51

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.

Question 52

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.

Question 53

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.

Question 54

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.