Chapter 8 Flashcards
The ______ determines the common attribute or attributes by looking for identically named attributes and compatible data types
Natural Join
When using a _________ , the output of an inner query is used as the input for the outer query.
Subquery
The having clause is used to restrict the output of a __________ query by applying a conditional criteria to the grouped rows.
HAVING
The IN subquery uses an ________ operator.
Equality
The use of the ________ operator allows you to compare a single value with a list of values returned by the first subquery using a comparison operator other than EQUALS
ALL
A _________ subquery is a subquery that executes once for each row in the outer query.
Correlated
The _______ statement combines the output of two SELECT queries.
UNION
A ________ query can be used to produce a relation that retains the duplicate rows.
UNION ALL
The _________ statement can be used to combine rows from two queries, returning only the rows that appear in both sets.
INTERSECT
If the DBMS does not support the INTERSECT statement, one can use an _________ to achieve the same result.
IN
An _________ view is a view that can be used to update attributes in the base tables that are used in the view.
Updatable
A _________ routine pools multiple transactions into a single batch to update a master table field in a single operation.
Batch Update
A row-level trigger requires use of the ____________ keywords and is executed once for each row affected by the triggering statement.
FOR EACH ROW
- When the critical application code is isolated in a single program, improves
Maintenance and Logic Control
_______ is the term used to describe an environment in which the SQL statement is not known in
advance and is generated at run time.
Dynamic SQL
