Chapter 7

SELECT

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

Subquery

A(n) _____, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.

Oracle

DATE() and SYSDATE are special functions that return today's date in MS Access and _____, respectively.

144

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

JOIN ON

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

TO_CHAR()

In Oracle, the _____ function converts a date to a character string.

outer

In subquery terminology, the first query in the SQL statement is known as the _____ query.

query

In the SQL environment, the word _____ covers both questions and actions.

GROUP BY

Rows can be grouped into smaller collections quickly and easily using the _____ clause within the SELECT statement.

COUNT

The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.

restricts the selection of grouped rows based on a condition.

The SQL data manipulation command HAVING:

HAVING

The _____ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

DEFAULT

The _____ command defines a default value for a column when no value is given.

DATE()

The _____ function returns the current system date in MS Access.

NOT IN

The _____ operator could be used in place of EXCEPT (MINUS) if the DBMS does not support it.

UNIQUE

The _____ specification is used to avoid having duplicated values in a column.

EXISTS

The special operator used to check whether a subquery returns any rows is _____.

BETWEEN

The special operator used to check whether an attribute value is within a range of values is _____.

"old-style" join

What type of command does this SQL statement use? SELECT P_CODE, P_DESCRIPT, P_PRICE_V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE=VENDOR. V_CODE

inner

When using a(n) _____ join, only rows from the tables that match on a common value are returned.

The outer subquery initiates the process of execution in a subquery.

Which is a feature of a correlated subquery?

Conversion

_____ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.

EXCEPT

_____ is a relational set operator.

Union-compatible

"_____" means that the names of the relation attributes must be the same and their data types must be alike.

Boolean

A specialty field in mathematics, known as _____ algebra, is dedicated to the use of logical operators.

wildcard

A(n) _____ character is a symbol that can be used as a general substitute for other characters or commands.

subquery

A(n) _____ is a query that is embedded (or nested) inside another query.

alias

A(n) _____ is an alternate name given to a column or table in any SQL statement.

Cross

A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables.

outer

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

COMMIT

The SQL command that allows a user to permanently save data changes is _____.

<>

Which comparison operator indicates a value is not equal?