Upgrade to remove ads
Only $35.99/year

Chapter 5 Practice Quiz/Quiz

Terms in this set (50)

​SQL Server does not support the MINUS operator.
True
​It is permissible to qualify all column names in a query.
True
When the innermost subquery is evaluated, a permanent table is produced.
False
To produce the same results as the INTERSECT operator, use the BETWEEN operator and a subquery.
False
​When using a DBMS without an optimizer, the formulation of a query can make a difference in the speed with which the query is executed.
True
You can use the ALL and ANY operators with subqueries to produce a single column of numbers.
True
​For two tables to be union compatible, the columns of the two tables must be identical.
False
​When joining tables, it is always necessary to qualify a column name.
False
You can join three tables together but not four tables.
False
You can join tables by using a condition in the WHERE clause.
True
​To ensure that query results are listed in a desired order, use the ORDER BY clause.
True
You can use the IN operator to retrieve data from multiple tables.
True
You must join tables by finding rows in the two tables that have identical values in matching columns.
True
In a nested query, the outer query is evaluated first.
False
You must use a comma or a period to separate a table name from its alias.
False
Recommended textbook explanations

Introduction to Algorithms

3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
709 explanations

Computer Organization and Design MIPS Edition: The Hardware/Software Interface

5th EditionDavid A. Patterson, John L. Hennessy
220 explanations

Engineering Electromagnetics

8th EditionJohn Buck, William Hayt
483 explanations

Starting Out with Java: From Control Structures through Objects

6th EditionTony Gaddis
1,224 explanations