Question 1

A full outer join will show records that contain NULL values.

Accepted Answer

A) True 
 B)False  True

Question 2

Examine the Sale and Cash Receipt relational tables and the corresponding query solution below. Which of the following SQL query statements applied to those tables will result in the depicted solution?

Accepted Answer

A)  SELECT CustomerID, Sum(Amount)FROM Sale; 
B)  SELECT CustomerID, Sum(Amount)FROM Sale GROUP BY CustomerID; 
C)  SELECT CustomerID, AmountFROM Sale; 
D)  SELECT CustomerID, Sum(Amount)FROM SaleWHERE CustomerID unique; 
E)  SELECT CustomerID, AmountFROM Sale GROUP BY Amount; 
A)  SELECT CustomerID, Sum(Amount)FROM Sale; 
B)  SELECT CustomerID, Sum(Amount)FROM Sale GROUP BY CustomerID; 
C)  SELECT CustomerID, AmountFROM Sale; 
D)  SELECT CustomerID, Sum(Amount)FROM SaleWHERE CustomerID unique; 
E)  SELECT CustomerID, AmountFROM Sale GROUP BY Amount; B

Question 3

Examine the relational tables depicted below. A user needs a query that includes InventoryStockID, and Description from the inventory table and the corresponding SaleIDs and Quantities Sold from the Stockflow1 table. Inventory items that have not yet been sold need to be included in the query result, with blanks showing for the corresponding Sale IDs and Quantities Sold. What kind of join is required to generate the desired result? Assume the Inventory table is the first table listed in the query statement (and is thus considered the "left" table) and the Stockflow table is the second table listed in the query statement (and is thus considered the "right"
Table).

Accepted Answer

A)  A left inner join is required 
B)  A right inner join is required 
C)  A right outer join is required 
D)  No join is required 
E)  A left outer join is required 
A)  A left inner join is required 
B)  A right inner join is required 
C)  A right outer join is required 
D)  No join is required 
E)  A left outer join is required E

Question 4

The answer to a query connecting two criteria with an AND logical operator will include all instances that meet either of the two criteria.

Accepted Answer

A) True 
 B)False

Question 5

Which operation would you use to total sales for each individual sales person.

Accepted Answer

A)  GROUP BY 
B)  WHERE 
C)  EQUALS 
D)  BETWEEN 
E)  NOT 
A)  GROUP BY 
B)  WHERE 
C)  EQUALS 
D)  BETWEEN 
E)  NOT

Question 6

Right outer join queries can only be created in relational algebra.

Accepted Answer

A) True 
 B)False

Question 7

Every SQL statement begins with the word PROJECT.

Accepted Answer

A) True 
 B)False

Question 8

Ad hoc querying is done primarily by professional database developers who use SQL.

Accepted Answer

A) True 
 B)False

Question 9

A parameter query requires a user to change the design of the query to reuse it with new parameter values.

Accepted Answer

A) True 
 B)False

Question 10

In Microsoft Access Query By Example, the inclusion of Criteria on two different lines as illustrated in the following query will

Accepted Answer

A)  Act as the AND logical operator and will include only those records that meet both of the criteria. 
B)  Act as the AND logical operator and will include all records that meet either of the two criteria. 
C)  Act as the OR logical operator and will include only those records that meet both of the criteria. 
D)  Act as the OR logical operator and will include all records that meet either of the two criteria. 
E)  Act as the NOT logical operator and will include only those records that meet neither of the two criteria. 
A)  Act as the AND logical operator and will include only those records that meet both of the criteria. 
B)  Act as the AND logical operator and will include all records that meet either of the two criteria. 
C)  Act as the OR logical operator and will include only those records that meet both of the criteria. 
D)  Act as the OR logical operator and will include all records that meet either of the two criteria. 
E)  Act as the NOT logical operator and will include only those records that meet neither of the two criteria.

Question 11

Given the following tables, what are the first and last names of the customers who have bought the "large, basic" product?

Accepted Answer

James Warr

Question 12

Query by Example (QBE) requires the end user to be able to construct a complex SQL Statement.

Accepted Answer

A) True 
 B)False

Question 13

A database includes the following tables. Design a query to display a count of the number of times each computer has been checked out, including zeros for those that have not yet been checked out. Include each computer's ID and the number of times it has been checked out. You may either write the query in SQL code or fill in the appropriate fields in the blank QBE design grid that follows the tables. The blank QBE design grid includes the "Total" line in case the query requires it; if the query does not use it, be sure to cross it off.

Accepted Answer

SELECT NotebookComputer.NCID,

Question 14

What will be the result of the following Microsoft Access QBE query of the CashDisbursement table?

Accepted Answer

The answer of What will be the result of the...

Question 15

SUM, MAX, and COUNT are examples of aggregation functions that may be included in both SQL and QBE queries.

Accepted Answer

A) True 
 B)False

Question 16

List the four types of JOINS that can be used in querying to combine data from multiple relational database tables. Explain how each type of JOIN works.

Accepted Answer

The four types of JOINS are Inner (also

Question 17

Relational algebra is most often used in practice to

Accepted Answer

A)  Lay the foundation of the underlying logical procedures in querying 
B)  Create queries that conform to the SELECT….. FROM….. WHERE….. format 
C)  Create queries using a point-and-click interface that requires little user expertise 
D)  Create queries that perform only mathematical operations 
E)  Create queries that perform only logical comparison operations 
A)  Lay the foundation of the underlying logical procedures in querying 
B)  Create queries that conform to the SELECT….. FROM….. WHERE….. format 
C)  Create queries using a point-and-click interface that requires little user expertise 
D)  Create queries that perform only mathematical operations 
E)  Create queries that perform only logical comparison operations

Question 18

Microsoft Access uses only a QBE method for query creation.

Accepted Answer

A) True 
 B)False

Question 19

What will be the result of the following SQL statement applied to the CashDisbursement table?
CashDisbursement
   SELECT Sum(Amount)
FROM CashDisbursement
WHERE Date  40204;

Accepted Answer

The answer of What will be the result of the...

Question 20

You can perform a right outer join on tables that do not share a common field.

Accepted Answer

A) True 
 B)False

A full outer join will show records that contain NULL values.

Examine the Sale and Cash Receipt relational tables and the corresponding query solution below. Which of the following SQL query statements applied to those tables will result in the depicted solution?

The answer to a query connecting two criteria with an AND logical operator will include all instances that meet either of the two criteria.

Which operation would you use to total sales for each individual sales person.

Right outer join queries can only be created in relational algebra.

Every SQL statement begins with the word PROJECT.

Ad hoc querying is done primarily by professional database developers who use SQL.

A parameter query requires a user to change the design of the query to reuse it with new parameter values.

In Microsoft Access Query By Example, the inclusion of Criteria on two different lines as illustrated in the following query will

Given the following tables, what are the first and last names of the customers who have bought the "large, basic" product?

Query by Example (QBE) requires the end user to be able to construct a complex SQL Statement.

What will be the result of the following Microsoft Access QBE query of the CashDisbursement table?

SUM, MAX, and COUNT are examples of aggregation functions that may be included in both SQL and QBE queries.

List the four types of JOINS that can be used in querying to combine data from multiple relational database tables. Explain how each type of JOIN works.

Relational algebra is most often used in practice to

Microsoft Access uses only a QBE method for query creation.

What will be the result of the following SQL statement applied to the CashDisbursement table? CashDisbursement SELECT Sum(Amount) FROM CashDisbursement WHERE Date <=2/05/2010 OR PayeeID > 40204;

You can perform a right outer join on tables that do not share a common field.

An Introduction to Integrated Enterprise Information Systems

Representation and Patterns

The REA Enterprise Ontology

The REA Enterprise Ontology: Business Process Modeling

Task Level Modeling

Relational Database Design

The Sales/Collection Business Process

The Acquisitio/Payment Business Process

View Integration and Implementation Compromises

The Conversion Business Process

The Human Resource Business Process

The Financing Business Process

Enterprise System Risks and Controls

ERP Systems and E-Commerce

Filters

Exam 7: Information Retrieval From Relational Databases

A full outer join will show records that contain NULL values.

Examine the Sale and Cash Receipt relational tables and the corresponding query solution below. Which of the following SQL query statements applied to those tables will result in the depicted solution?

The answer to a query connecting two criteria with an AND logical operator will include all instances that meet either of the two criteria.

Which operation would you use to total sales for each individual sales person.

Right outer join queries can only be created in relational algebra.

Every SQL statement begins with the word PROJECT.

Ad hoc querying is done primarily by professional database developers who use SQL.

A parameter query requires a user to change the design of the query to reuse it with new parameter values.

In Microsoft Access Query By Example, the inclusion of Criteria on two different lines as illustrated in the following query will

Given the following tables, what are the first and last names of the customers who have bought the "large, basic" product?

Query by Example (QBE) requires the end user to be able to construct a complex SQL Statement.

What will be the result of the following Microsoft Access QBE query of the CashDisbursement table?

SUM, MAX, and COUNT are examples of aggregation functions that may be included in both SQL and QBE queries.

List the four types of JOINS that can be used in querying to combine data from multiple relational database tables. Explain how each type of JOIN works.

Relational algebra is most often used in practice to

Microsoft Access uses only a QBE method for query creation.

What will be the result of the following SQL statement applied to the CashDisbursement table? CashDisbursement SELECT Sum(Amount) FROM CashDisbursement WHERE Date <=2/05/2010 OR PayeeID > 40204;

You can perform a right outer join on tables that do not share a common field.

An Introduction to Integrated Enterprise Information Systems

Representation and Patterns

The REA Enterprise Ontology

The REA Enterprise Ontology: Business Process Modeling

Task Level Modeling

Relational Database Design

The Sales/Collection Business Process

The Acquisitio/Payment Business Process

View Integration and Implementation Compromises

The Conversion Business Process

The Human Resource Business Process

The Financing Business Process

Enterprise System Risks and Controls

ERP Systems and E-Commerce

Filters