Ch 4 Practice Exam

An inequality condition is also known as a natural join and an equality condition is also called a theta join.

When using a(n) _____ join, only rows that meet the given criteria are returned.

The statement SELECT * FROM T1, T2 produces a(n) _____ join.

A(n) _____ join will select only the rows with matching values in the common attribute(s).

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.

The ANSI standard defines _____ type(s) of outer join(s).

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.

The syntax for a left outer join is _____.

A _____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.

All join conditions are connected through a(n) _____ logical operator.

An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2 _____ (common-column).

The ______ determines the common attribute or attributes by looking for identically named attributes and compatible data types.

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

_____ is a query inside a query.

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

What is a feature of a correlated subquery?

When using a subquery, the output of an _____ query is used as the input for the outer query.

The ____ clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

The IN subquery uses an ____ operator.

The use of the ____ operator allows you to compare a single value with a list of values returned by the first subquery (sqA) using a comparison operator other than EQUALS.

A ____ subquery is a subquery that executes once for each row in the outer query.

In the context of SELECT subquery types, a _____ is returned when an UPDATE subquery is used.

When using the Oracle TO_DATE function, the code _____ represents a three-letter month name.

The Oracle _____ function returns the current date.

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

The Oracle string concatenation operator is _____.

____ is a string function that returns the number of characters in a string value.

When using the Oracle TO_NUMBER function to convert a character string into a number, _____ represents a digit.

The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

Oracle uses the ____ function to extract the various parts of a date.

____ functions extract a value of a given data type and convert it to the equivalent value in another data type.

____ is a relational set operator.

"Union compatible" means that the _____.

The _____ data type is compatible with NUMBER.

The _____ statement combines rows from two queries and excludes duplicates.

The syntax for the UNION query is _____.

Assume a designer is using the UNION operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Jenna and Howard are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator?

Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator?

Assume you are using the INTERSECT operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the INTERSECT operator?

The _____ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the MINUS operator?

The _____ operator could be used in place of INTERSECT if the DBMS does not support it.

The _______ operator could be used in place of MINUS if the DBMS does not support it.

The ____ statement combines the output of two SELECT queries and returns all results common to both queries.

An ____ query can be used to produce a relation that retains the duplicate rows.

The ____ statement can be used to combine rows from two queries, returning only the rows that appear in both sets.

The syntax of the MINUS statement in Oracle is ____.

If the DBMS does not support the INTERSECT statement, one can use an ____ subquery to achieve the same result.

UNION, INTERSECT, and MINUS work properly only if relations are intersect-compatible, which means that the names of the relation attributes and their data types must be different.

An ____ view is a view that can be used to update attributes in the base tables that are used in the view.

A _____ routine pools multiple transactions into a single batch to update a master table field in a single operation.