Question 1

When you edit a crosstab query in Design view,you use the ________ and ________ rows in the design grid to specify which field value becomes the column heading,which field values become row headings,and which field's value to calculate.

Accepted Answer

The answer of When you edit a crosstab query in...

Question 2

A(n)________ is used to query unrelated tables or queries and combine the results into a single dataset.This type of query is different from querying related tables as it combines two SQL SELECT statements.

Accepted Answer

The answer of A(n)________ is used to query unrelated tables...

Question 3

A(n)________ is a special type of query that can be created when you want to describe one number in terms of two other numbers.

Accepted Answer

The answer of A(n)________ is a special type of query...

Question 4

Match the following terms to their definition:
I.SELECT
II.FROM
III.WHERE
IV.AS
V.HAVING
A.Includes field names
B.Specifies the rows returned in the dataset
C.Specifies aggregated field criteria
D.Includes table names
E.Used to rename fields

Accepted Answer

The answer of Match the following terms to their definition:
I.SELECT
II.FROM
III.WHERE
IV.AS
V.HAVING
A.Includes...

Question 5

The SQL ________ clause includes the Name of the table(s)from which the information is retrieved.

Accepted Answer

The answer of The SQL ________ clause includes the Name...

Question 6

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

The answer of The WHERE clause,which is optional in a...

Question 7

The SQL ________ clause specifies which table rows are used.

Accepted Answer

The answer of The SQL ________ clause specifies which table...

Question 8

The ________ clause sorts the result of a query according to the values in one or more specific columns.

Accepted Answer

The answer of The ________ clause sorts the result of...

Question 9

A subquery is usually added in the ________ clause of the SQL SELECT statement.

Accepted Answer

The answer of A subquery is usually added in the...

Question 10

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

Accepted Answer

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

Question 11

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 12

The ________ clause returns all rows from at least one of the tables within the FROM clause,as long as those rows meet any WHERE or HAVING search conditions.

Accepted Answer

The answer of The ________ clause returns all rows from...

Question 13

A crosstab query is different than the aggregate functions that you have been completing thus far because it groups the aggregates by the ________ and ________ headings.

Accepted Answer

The answer of A crosstab query is different than the...

Question 14

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

Accepted Answer

The answer of The ________ is the easiest way to...

Question 15

Joins are performed based on a(n)________,which specifies the condition to use in order to perform a join.

Accepted Answer

The answer of Joins are performed based on a(n)________,which specifies...

Question 16

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 17

Match the following terms to their definition:
I.INNER JOIN
II.OUTER JOIN
III.FULL JOIN
IV.Union query
V.SQL subquery
A.Returns only the rows that actually match
B.Returns all rows from both tables
C.Usually added in the WHERE clause
D.Returns all rows from at least one of the tables
E.Combines two SQL SELECT statements

Accepted Answer

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

Question 18

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 19

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 20

The ________ clause is used to return only the rows that actually match based on the join predicate.

Accepted Answer

The answer of The ________ clause is used to return...

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

When you edit a crosstab query in Design view,you use the and rows in the design grid to specify which field value becomes the column heading,which field values become row headings,and which field's value to calculate.