Chapter 7

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.

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 _____.

COMMIT

The SQL command that allows a user to permanently save data changes 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.

<>

Which comparison operator indicates a value is not equal?

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.