Databases Reference
In-Depth Information
(c)
when adding rows to the source table.
(d)
when filtering the result by a range
8.
Which keyword is used to filter query results by a range of values?
(a)
GROUP BY
(b)
IN
(c)
BETWEEN
(d)
INTO
9.
By default, a query will return duplicate rows in the result set. True or
False?
10.
A WHERE clause includes both AND and OR operators. Which
statement best describes how they are processed?
(a)
AND operators are processed first by default.
(b)
OR operators are processed first by default.
(c)
Operators are processed left to right by default without regard for the
operator type.
(d)
Operators are processed right to left by default without regard for the
operator type.
11.
A cross join of two tables, each with six rows, would contain how many
rows in the result set?
(a)
none
(b)
6
(c)
12
(d)
36
12.
An inner join returns only those rows that qualify from both joined
tables. True or False?
13.
A SELECT statement used to join tables can include no more than two
tables. True or False?
14.
An operation can be performed as a join or subquery. Which typically
makes best use of available resources?
(a)
join
(b)
subquery
(c)
Both make equal use of available resources.
15.
Where is the join operator specified when joining two tables?
(a)
in the FROM clause, as an ON statement
(b)
in the WHERE clause, using a comparative operator
(c)
in either a or b
(d)
in neither a nor b
