AIS 3180 - Chapter 4

Which of the following is a correct statement about foreign keys? a) All foreign keys cannot not be null (blank) b) Most foreign keys should not have any data values c) The data values of a forging key always exist in the corresponding table d) Foreign keys could be null

a) All foreign keys cannot not be null (blank)

Which of the following is a correct statement about primary keys? a) The data values of a primary key must be different (i.e. unique) b) A primary key is always another table's foreign key c) A primary cannot be used in another table as a foreign key d) Most tables in a database may not require a primary key

a) The data values of a primary key must be different (i.e. unique)

The GROUP BY operator in SQL is used to: a) aggregate functions on the query results based on one or more columns b) identify which columns are used to sort the resulting data c) state the criteria that must be met to be shown in the query result d) indicate the name of the table from which to retrieve data

a) aggregate functions on the query results based on one or more columns

Advantages of relational data models generally include: a) reduced information redundancy b) low cost c) ease of implementation d) efficiency

a) reduced information redundancy

When using Microsoft Access, the main function of table is to: a) store data b) report data c) retrieve data d) analyze data

a) store data

The "ORDER BY Amount ASC" clause to the SELECT statement used in SQL suggests that: a) the amount of the query result will be listed in ascending order b) the amount of the query result will be listed in descending order c) the data attribute of ASC will be shown in order d) None of the above

a) the amount of the query result will be listed in ascending order

The FROM clause to the SELECT statement used in SQL indicates: a) the name of the tables from which to retrieve data b) the name of the column from which to retrieve data c) the name of the database from which to retrieve data d) the name of the query from which to retrieve data

a) the name of the tables from which to retrieve data

In the hierarchical data model, the mapping from parent to child is: a) 1:1 b) 1:* c) *:* d) *:1

b) 1:*

Which of the following could be a relationship table? a) Purchase Order table b) Purchase line item table c) Inventory Receipt table d) Disbursements table

b) Purchase line item table

Which statement about enterprise systems is correct? a) Most enterprise systems are designed mainly for accounting and finance functions b) SAP, Oracle, and Microsoft all offer products for enterprise systems c) Most enterprise systems are designed for the service industry d) Small companies do not use enterprise systems at all

b) SAP, Oracle, and Microsoft all offer products for enterprise systems

Which of the following is used in SQL to begin a query? a) BEGIN b) SELECT c) INPUT d) INSERT

b) SELECT

Which of the following could be an event in an REA data model? a) Cash b) Sales c) Customer d) Inventory

b) Sales

When using Microsoft Access, the main function of Form is to: a) store data b) enter data c) retrieve data d) analyze data

b) enter data

Cloud Computing: a) takes energy from the sun and clouds b) is internet-based computing where shared resources, software, and information are provided to firms on demand c) requires firms to make an extensive investment in hardware and software to meet firm needs d) can meet computing needs today but us not expected to meet tomorrow's computing needs

b) is internet-based computing where shared resources, software, and information are provided to firms on demand

Which of the following is a valid primary key for a cash receipt table? a) Purchase Order Number b) Check Number c) Cash Receipt Number d) Receipt Amount

c) Cash Receipt Number

SAP modules available for implementation include: a) Payroll, Personnel Time Management, and Enterprise Management b) Payroll, Financial Accounting, and Enterprise Management c) Financial Accounting, Payroll, and Sales and Distribution d) Sales and Distribution, Financial Accounting, and Procurement

c) Financial Accounting, Payroll, and Sales and Distribution

Which of the following is a correct statement about entity integrity rule? a) The rule is regarding how to use foreign keys b) The rule is used to verify the type of data values in each table c) The rule requires each records primary key cannot be null d) The rule allows each primary key must be used to link tables

c) The rule requires each records primary key cannot be null

A class in a relational database model is defined as: a) the sum of the whole b) characteristics or properties of a Table c) person, place, thing, transaction, or event about which information is stored. d) being, or existence, especially when considered as distinct, independent, or sel-contained

c) person, place, thing, transaction, or event about which information is stored.

When using Microsoft Access, the main function of Query is to: a) store data b) enter data c) retrieve data d) analyze data

c) retrieve data

Which of the following is the BEST primary key for cash disbursements table: a) Purchase Order Number b) Check Number c) Inventory Receipt Number d) Disbursement voucher Number

d) Disbursement voucher Number

What is referential integrity rule? a) Primary keys cannot be null b) Foreign keys cannot be null c) The data values of forging keys always exist in the corresponding table d) Foreign keys could be null

d) Foreign keys could be null

Which of the following is not a valid link between tables? a) Linking Sales table to Inventory table b) Linking Purchase table to Cash Disbursements table c) Linking Salespeople table to Customer table d) Linking Vendor table to Customer table

d) Linking Vendor table to Customer table

What kind of relationship does a network data model represent? a) One-to-One b) One-to-Many c) Many-to-One d) Many-to-Many

d) Many-to-Many

Refer to Figure 4.2: if Steve's Stylin' Sunglasses accepts installments without requiring a down payment, the multiplicities between Sales and Cash Receipts should be changed to: a) Sales (0:1) - (1:*) Cash Receipts b) Sales (1:1) - (0:*) Cash Receipts c) Sales (1:1) - (1:1) Cash Receipts d) Sales (0:1) - (1:1) Cash Receipts e) None of the above

d) Sales (0:1) - (1:1) Cash Receipts

The WHERE clause to the SELECT statement use din SQL states the criteria that must be met: a) to run the query b) to be included in the attribute table c) to be included in the database d) to be shown in the query results

d) to be shown in the query results