Chapter 7 Quiz

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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.


Set pelajaran terkait

Criminal Procedure Examples Only

View Set

Economics 2314 Final Bruce McClung

View Set

TEFL FULLCIRCLE- End of Module Assessments

View Set

Review HDFS Prenatal Development

View Set

EN 206 Unit 3: The English Modern Period: Quotes/Notes Exam 3 Pionke

View Set

Chapter 40: Oxygenation and Perfusion

View Set

Growth and Development NCLEX Q's (CH2- Davis Peds Success)

View Set