Question 1

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

Accepted Answer

The Crosstab Query Wizard is specifically designed to create crosstab queries and guides the user through the process by asking for appropriate input to generate the desired output. The other wizards are not specific to crosstab queries and may not provide the same level of guidance for this type of query.

Question 2

Even though you can select all the fields from a table,you cannot use a(n)________ in a query in which you are using the GROUP BY clause.

Accepted Answer

The asterisk (*) represents all the fields in a table, but when using the GROUP BY clause in a query, all fields that are not part of the GROUP BY clause need to be aggregated using a function such as SUM, COUNT, AVG, MAX, or MIN. When using the asterisk, it is not clear which fields need to be aggregated, which can lead to errors in the query.

Question 3

Many programs use a modified version of SQL.If standard SQL is written in SQL view,the query will ________.

Accepted Answer

Standard SQL written in SQL view will still run properly and return the correct dataset, as SQL view is designed to interpret and execute standard SQL queries.

Question 4

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

A crosstab query is specifically designed to summarize data by groups and includes calculations such as sums, averages, and counts, making it useful for describing one number in terms of two other numbers.

Question 5

The following SELECT statement: SELECT EmpFirstName,EmpLastName
FROM tblEmployee
WHERE EmpLastName Like "[D-G]*";
Would list the EmpFirstName and EmpLastName that ________.

Accepted Answer

The statement uses the LIKE operator with a wildcard pattern matching all last names that start from D to G. It selects the EmpFirstName and EmpLastName fields from the tblEmployee table, which lists all employees whose last names begin with D, E, F, or G, sorted in ascending order.

Question 6

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

Accepted Answer

Crosstab queries group aggregates by both column and row headings, allowing for comparison between multiple categories within the data.

Question 7

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

When using an aggregate function in SQL, the HAVING clause is used to filter results based on conditions applied to the result of the aggregate function. The WHERE clause is used to filter results based on conditions applied to specific columns in the table. The FROM clause specifies the table or tables being queried, and the AS clause is used to rename table columns or alias tables.

Question 8

When writing SQL,you cannot use a renamed field in the ________ clause.You must use the original field name.

Accepted Answer

The answer of When writing SQL,you cannot use a renamed...

Question 9

The following SELECT statement: SELECT *
FROM tblCustomers
WHERE LastName Like "smith";
Would list ________.

Accepted Answer

The LIKE operator with "smith" (without any wildcard characters) will match records where the LastName is exactly "smith".

Question 10

The following SELECT statement: SELECT ProductName,ProductPrice
FROM tblInventory
WHERE ProductName Like "pr*";
Would list the ProductName and ProductPrice that ________.

Accepted Answer

The SELECT statement uses the Like operator with the wildcard character * to match all products that begin with the letters "pr". The WHERE clause filters the results based on this criteria, and only the ProductName and ProductPrice columns are selected. There is no mention of sorting in this statement.

Question 11

Which of the following is NOT true in regard to crosstab queries?

Accepted Answer

Crosstab queries are not the same type of query as those which perform aggregate functions. Crosstab queries are used to present data in a summarized format, while aggregate queries are used to perform calculations on a set of data.

Question 12

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

Accepted Answer

A subquery is usually added in the WHERE clause of the SQL SELECT statement to filter the results based on some condition or criteria specified in the subquery. The subquery is enclosed in parentheses and can be nested within other subqueries or combined with other clauses such as EXISTS or NOT EXISTS.

Question 13

Which of the following is NOT true regarding inner joins?

Accepted Answer

Inner joins are not subdivided into left inner joins, right inner joins, or full inner joins. Inner joins simply return the rows that match based on the join predicate, and the output includes only where the two tables intersect or overlap.

Question 14

Which of the following is NOT true in regard to writing a SQL subquery?

Accepted Answer

A SQL subquery is a separate SELECT statement that is nested inside, not outside, the main SELECT statement.

Question 15

When you create a query in Design view,Access automatically generates the ________ in the background.

Accepted Answer

When you create a query in design view, Access automatically generates the SQL statement in the background. This SQL statement essentially describes the logic of your query, specifying which tables to include, which fields to display or analyze, and how to filter, sort, and group the data. The SQL statement can also be modified directly in SQL view, allowing for more advanced and specific queries.

Question 16

Which of the following is NOT true in regard to the Crosstab Query Wizard?

Accepted Answer

The answer of Which of the following is NOT true...

Question 17

Which of the following is NOT true regarding outer joins?

Accepted Answer

An OUTER JOIN does not require rows to meet WHERE or HAVING conditions to return all rows from one table; it returns all rows from one table and the matched rows from the other table, or NULLs if no match is found.

Question 18

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 WHERE clause filters the rows that match a specific condition in the table, narrowing down the dataset that is returned. It does not affect the fields, aggregated data, or aggregated calculations in the query.

Question 19

When working in SQL,other ________ can be used,such as AND,OR,or IN.

Accepted Answer

Operators like AND, OR, and IN are used in SQL to filter and manipulate data. Group by methods and aggregated calculations are used for organizing and performing mathematical operations on data in SQL, while subqueries are used to retrieve data from nested queries.

Question 20

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

A union query is used to combine the results of two SQL SELECT statements that have similar structures. It is commonly used to query unrelated tables or queries and combine the results into a single dataset. The resulting dataset will include all the rows from both SELECT statements, and duplicates will be removed.

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

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

Even though you can select all the fields from a table,you cannot use a(n) ________ in a query in which you are using the GROUP BY clause.

Many programs use a modified version of SQL.If standard SQL is written in SQL view,the query will ________.

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.

The following SELECT statement: SELECT EmpFirstName,EmpLastName FROM tblEmployee WHERE EmpLastName Like "[D-G]*"; Would list the EmpFirstName and EmpLastName that ________.