Site MapHelpFeedbackTrue or False Quiz
True or False Quiz
(See related pages)



1

SQL supports one-sided outer join operations with the keywords LEFT JOIN and RIGHT JOIN in queries.
A)True
B)False
2

An alternative method of formulating a full outer join would be to take the union of the results tables from two one-sided outer joins.
A)True
B)False
3

A type I query may reference a column in the outer query.
A)True
B)False
4

Type I nested queries cannot be used when the result table contains any columns from the nested query.
A)True
B)False
5

A Type II nested query may not reference a column in the outer query.
A)True
B)False
6

Most difference problems can be solved by either using a Type I nested query, a Type II nested query, or an inequality join, and the choice is a matter of preference.
A)True
B)False
7

In simple conditions involving a single comparison of two columns or column expression, a null value results if either column or column expression in the comparison is null.
A)True
B)False
8

SQL:2003 uses three-valued logic to evaluate the result of compound conditions.
A)True
B)False
9

In the flowing query, the value for NumRows and the value for NumFaculty would always have to be the same.

SELECT COUNT(*) AS NumRows, COUNT(FacSSN) AS NumFaculty
FROM Offering
A)True
B)False
10

COUNT is the only aggregate function which can be affected by the presence of null values in the aggregate column(s).
A)True
B)False





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 9 > True or False Quiz