Question 1

Which of the following is NOT true regarding inner joins?

Accepted Answer

A) The INNER JOIN clause is used to return only the rows that actually match based on the join predicate. 
B) An inner join is a join in which the values in the columns being joined are equal. 
C) Inner joins are subdivided into left inner joins,right inner joins,and full inner joins,depending on which table rows are shown in the dataset. 
D) The output of an inner join will include where the two tables intersect or overlap.

Question 2

The WHERE clause,which is optional in a SELECT statement,narrows the query results by specifying which ________ in the table will be returned in the dataset.

Accepted Answer

A) fields 
B) rows 
C) aggregated data 
D) aggregated calculation

Question 3

The word ________ simply means a summative calculation,such as a total or average,or summarizing data.

Accepted Answer

The answer of The word ________ simply means a summative...

Question 4

The SQL WHERE clause specifies which table rows are used.

Accepted Answer

A) True 
 B)False

Question 5

When writing SQL,the ________ selects and returns all fields in the table when you run the query.

Accepted Answer

A) semicolon 
B) ampersand 
C) asterisk 
D) dollar sign

Question 6

The SQL ________ clause includes one or more columns from which data are retrieved.

Accepted Answer

A) SELECT 
B) FROM 
C) WHERE 
D) AS

Question 7

A(n)________ is a separate SELECT statement that is nested inside the main SELECT statement.

Accepted Answer

The answer of A(n)________ is a separate SELECT statement that...

Question 8

The Crosstab Query Wizard is the easiest way to create a crosstab query because all settings can be established within the wizard.

Accepted Answer

A) True 
 B)False

Question 9

Match the following terms to their definition:
I.Physical volume
II.Percentage of sales revenue
III.Percentage of sales volume
IV.Revenue
V.Net revenue
A.Compares how two or more numbers are related
B.Measures space within an object
C.Revenue minus sales returns,allowances,and discounts
D.Gross sales
E.Compares gross revenue to total gross revenue

Accepted Answer

The answer of Match the following terms to their definition:
I.Physical...

Question 10

Which of the following is NOT true in regard to calculating physical volume?

Accepted Answer

A) The basic formula for calculating volume is length*width*depth. 
B) If the item is not a perfect rectangle,take the average width and length.For example,if the object is 6 inches at its widest point and 2 inches at its narrowest point,use 4 inches for the width. 
C) If you are wrapping the item in bubble wrap,take your measurements before it is wrapped. 
D) If you take your measurements in inches,your final calculation will be in cubic inches.If you take them in centimeters,your final calculation will be in cubic centimeters,and so on.

Question 11

When working with SQL,if a field includes an aggregate function,you need to use a(n)________ clause,which specifies the aggregated field criteria and restricts the results based on aggregated values.

Accepted Answer

A) WHERE 
B) HAVING 
C) FROM 
D) AS

Question 12

________ is one of the most important pieces of information that a company uses to learn more about its financial progress.

Accepted Answer

The answer of ________ is one of the most important...

Question 13

When working with SQL,if a field includes an aggregate function,you need to use a ________ clause,which specifies the aggregated field criteria and restricts the results based on aggregated values.

Accepted Answer

The answer of When working with SQL,if a field includes...

Question 14

Which of the following is NOT true regarding outer joins?

Accepted Answer

A) The OUTER JOIN clause returns all rows from two or more of the tables within the FROM clause,as long as those rows meet any WHERE or HAVING search conditions. 
B) The OUTER JOIN clause is used whenever multiple tables that are accessed through a SQL SELECT statement returns all of the records from one table and only those records from the other table where the joined fields match. 
C) The LEFT JOIN clause is used when you want to return all rows in the left table,even if no matching rows exist in the right table. 
D) The FULL OUTER JOIN clause is not supported in Microsoft Access.

Question 15

The ________ is the easiest way to create a crosstab query.

Accepted Answer

A) Crosstab Query Wizard 
B) Union Query Wizard 
C) SQL Query Wizard 
D) Subquery Wizard

Question 16

Sum can only be performed on number and currency fields.Count can be done on any field data type,except number and currency fields.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is NOT a reason to work in Design view when creating or editing a crosstab query?

Accepted Answer

A) When you want to use fields from multiple tables or queries 
B) When you want to specify column headings 
C) When you want to add a parameter to your query 
D) When you want to add an expression to your query

Question 18

When writing SQL,the ________ selects and returns all fields in the table when you run the query.

Accepted Answer

The answer of When writing SQL,the ________ selects and returns...

Question 19

The benefit of learning SQL is that once you know it,you can easily adapt to other relational database management systems.

Accepted Answer

A) True 
 B)False

Question 20

The SQL ________ clause includes one or more columns from which data are retrieved.

Accepted Answer

The answer of The SQL ________ clause includes one or...

Exam 7: Workshop 7: Aggregated Calculations, Subquerying, and Sql

Which of the following is NOT true regarding inner joins?

The WHERE clause,which is optional in a SELECT statement,narrows the query results by specifying which ________ in the table will be returned in the dataset.

The word ________ simply means a summative calculation,such as a total or average,or summarizing data.

The SQL WHERE clause specifies which table rows are used.

When writing SQL,the ________ selects and returns all fields in the table when you run the query.

The SQL ________ clause includes one or more columns from which data are retrieved.

A(n)________ is a separate SELECT statement that is nested inside the main SELECT statement.

The Crosstab Query Wizard is the easiest way to create a crosstab query because all settings can be established within the wizard.

Which of the following is NOT true in regard to calculating physical volume?

When working with SQL,if a field includes an aggregate function,you need to use a(n) ________ clause,which specifies the aggregated field criteria and restricts the results based on aggregated values.

________ is one of the most important pieces of information that a company uses to learn more about its financial progress.

When working with SQL,if a field includes an aggregate function,you need to use a ________ clause,which specifies the aggregated field criteria and restricts the results based on aggregated values.

Which of the following is NOT true regarding outer joins?

The ________ is the easiest way to create a crosstab query.

Sum can only be performed on number and currency fields.Count can be done on any field data type,except number and currency fields.

Which of the following is NOT a reason to work in Design view when creating or editing a crosstab query?

When writing SQL,the ________ selects and returns all fields in the table when you run the query.

The benefit of learning SQL is that once you know it,you can easily adapt to other relational database management systems.

The SQL ________ clause includes one or more columns from which data are retrieved.