Chapter 7 Quiz

A named set of SQL statements that are considered when a data modification occurs are called:

triggers

In which of the following situations would one have to use an outer join in order to obtain the desired results?

A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

natural join.

All of the following are guidelines for better query design EXCEPT:

use a lot of self-joins.

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

using the CASE keyword in a statement.

________ use the result of the outer query to determine the processing of the inner query.

Correlated subqueries

In order to embed SQL inside of another language, the ________ statement must be placed before the SQL in the host language.

EXEC SQL

________ takes a value of TRUE if a subquery returns an intermediate results table which contains one or more rows.

Exists

SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query.

SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query.

The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID =(SELECT Order_T.CustomerIDFROM Order_T WHERE OrderID = 1008);

Subquery.

The following code would include:SELECT Customer_T.CustomerID,CustomerName, OrderIDFROM Customer_T LEFT OUTER JOIN Order_T ONCustomer_T.CustomerID = Order_T.CustomerID;

all rows of the Customer_T Table regardless of matches with the Order_T Table.

The MERGE command:

allows one to combine the INSERT and UPDATE operations.

A join in which the joining condition is based on equality between values in the common columns is called a(n):

both A and C.

A join operation:

causes two tables with a common domain to be combined into a single table or view.

The UNION clause is used to:

combine the output from multiple queries into a single result table.

A ________ is a temporary table used in the FROM clause of an SQL query.

derived table

The following code is an example of a(n): SELECT Customer_T.CustomerID,Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID;

equi-join.

Dynamic SQL:

is used to generate appropriate SQL code on the fly as an application is processing.

While triggers run automatically, ________ do not and have to be called.

routines

A type of join where a table is joined to itself is called a(n):

self-join.