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

The ________ function truncates the decimal and returns only the numbers to the left of the decimal.

________ Language is an internationally recognized standard database language used by many relational databases.

When writing SQL,be certain to write each clause of the SELECT statement on separate lines or the query will not run.

A subset query is a select query that is nested inside of another select query.

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.

A(n)________ returns a single value calculated from multiple values in a column.

Which of the following is NOT an example of a common aggregate function?

A(n)________ returns a single value calculated from multiple values in a column.

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

The salon and spa's management team wants to create a phone directory from both the Client table and Employee table of data.Management should use a crosstab query.

Many managers require ________ data in order to make decisions.

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

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.

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

Joins are performed based on a predicate,which specifies the condition to use in order to perform a join.

The Where function allows you to limit the results of your query by specifying criteria that field values must meet without using that field to group the data mathematically.

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

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

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

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