Chapter 6 (Final)

Question 1

An SQL query that implements an outer join will return rows that do not have matching values in common columns.

Answer 1

True

Question 2

It is better not to have a result set identified before writing GROUP BY and HAVING clauses for a query.

Answer 2

False

Question 3

A subquery in which processing the inner query depends on data from the outer query is called a codependent query.

Answer 3

False

Question 4

A join in which the joining condition is based on equality between values in the common column is called an equi-join.

Answer 4

True

Question 5

MULTISET is similar to the table datatype.

Answer 5

False

Question 6

The natural join is very rarely used.

Answer 6

False

Question 7

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):

Answer 7

natural-join

Question 8

The ________ DBA view shows information about all users of the database in Oracle.

Answer 8

DBA_USERS

Question 9

Establishing IF-THEN-ELSE logical processing within an SQL statement can now be accomplished by using the CASE keyword in a statement.

Answer 9

True

Question 10

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;

Answer 10

equi-join.

Question 11

The outer join syntax does not apply easily to a join condition of more than ________ tables.

Answer 11

two

Question 12

When a subquery is used in the FROM clause, it is called a denied table.

Answer 12

False

Question 13

Subqueries can only be used in the WHERE clause.

Answer 13

False

Question 14

A base table is the underlying table that is used to create views.

Answer 14

True

Question 15

All of the following are advantages of SQL-invoked routines EXCEPT:

Answer 15

security.

Question 16

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

Answer 16

Exists

Question 17

All of the following are part of the coding structure for triggers EXCEPT:

Answer 17

selection

Question 18

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

Answer 18

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

Question 19

EXISTS will take a value of ________ if the subquery returns an intermediate results table which contains one or more rows.

Answer 19

true

Question 20

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

Answer 20

derived table

Question 21

The following code would include:

SELECT Customer_T.CustomerID, Order_T.CustomerID,
CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;

Answer 21

only rows that match both Customer_T and Order_T Tables.

Question 22

The advantages of SQL-invoked routines are flexibility, efficiency, sharability, and applicability.

Answer 22

True

Question 23

The following SQL statement is an example of a correlated subquery.

SELECT First_Name, Last_Name, Total_Sales
FROM Salesman s1
WHERE Total_Sales > all 
(SELECT Total_Sales FROM Salesman s2
WHERE s1.Salesman_ID != s2.Salesman_ID);

Answer 23

True

Question 24

In SQL, a(n) ________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.

Answer 24

correlated

Question 25

The following code is an example of a:

SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,
CustomerPostalCode
FROM Customer_T
WHERE Customer_T.CustomerID =
(SELECT Order_T.CustomerID
FROM Order_T
WHERE OrderID = 1008);

Answer 25

subquery