Deck 4: Single-Table Queries

Full screen (f)
exit full mode
Question
When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.
Use Space or
up arrow
down arrow
to flip the card.
Question
To specify that query results be listed in a specific order, use the SORT BY clause.
Question
Sometimes a condition involves a column that can accept null values.
Question
The GROUP BY clause sorts the data in a particular order.
Question
The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.
Question
MySQL supports only the version of the "not equal to" comparison operator.
Question
The HAVING clause is used to restrict groups.
Question
In a SELECT statement, the FROM clause and the WHERE clause (when used)must appear on separate lines.
Question
The MIN function determines the minimum value in a row.
Question
It is possible to place one query inside another.
Question
The WHERE clause applies to both rows and groups.
Question
When you query a database, there is a defined order in which the results are displayed.
Question
Aggregate functions apply to groups of rows.
Question
Preceding a condition by the NOT operator reverses the truth of the original condition.
Question
There are no special formatting rules in MySQL.
Question
You cannot assign names to computed columns.
Question
The BETWEEN operator is an essential feature of SQL.
Question
An arithmetic column is a column that does not exist in the database but can be computed using data in existing columns.
Question
All SELECT statements require a WHERE clause.
Question
You cannot change the order of the columns to be displayed in query results.
Question
The basic form of the SQL SELECT command is ____.

A)FROM-SELECT-WHERE
B)SELECT-FROM-WHERE
C)FROM-WHERE-SELECT
D)WHERE-SELECT-FROM
Question
When data is sorted on two columns, the more important column is called the major sort key.
Question
The ____ wildcard symbol represents any individual character.

A)%
B)_
C)/
D)\
Question
It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.
Question
The ____ operator is inclusive, meaning that a value equal to either value would be selected.

A)AND
B)BETWEEN
C)OR
D)NOT
Question
After the word FROM in a SELECT statement, you list any conditions (restrictions)that apply to the data you want to retrieve.
Question
A simple condition has the form: column name, comparison operator, and then either another column name or a value.
Question
You can use computed columns in comparisons.
Question
The DISTINCT operator is useful when used in conjunction with the COUNT function.
Question
The UNIQUE operator eliminates duplicate values in a query.
Question
In SQL, the ____ symbol is used as a wildcard to represent any collection of characters.

A)*
B)%
C)?
D)!
Question
You form compound conditions by connecting two or more simple conditions using the ____ operators.

A)AND
B)OR
C)NOT
D)All of the above
Question
The COUNT function only applies to columns with numeric values.
Question
In a nested query, the outquery is evaluated first .
Question
To sort records in descending order, follow the name of the sort key with the REVERSE operator.
Question
When the OR operator connects simple conditions, the compound condition will be true whenever any one of the simple conditions is true.
Question
In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.

A)\
B)/
C)*
D)?
Question
In SQL, you use the ____ command to query a database.

A)WHERE
B)SELECT
C)FROM
D)SET
Question
The WHERE clause is used to limit the rows that are included in a query's result.
Question
Which of the following operators can be used for a column computation?

A)+
B)^
C)**
D)All of the above
Question
You use the ____________________ clause to retrieve rows that satisfy some condition.
Question
The ____ function calculates a total of the values in a column.

A)TOTAL
B)CALCULATE
C)SUM
D)ADD
Question
Preceding a condition by the ____ operator reverses the truth of the original condition.

A)><
B)NOT
C)NULL
D)OR
Question
The ____________________ operator uses one or more wildcard characters to test for a pattern match.
Question
A(n)____________________ clause provides a concise way of phrasing certain conditions.
Question
A(n)____________________ is simply a question represented in a way that the DBMS can understand.
Question
The ____ function determines the number of rows in a table.

A)ROW
B)CALCULATE
C)COUNT
D)NUMBER
Question
To include spaces in computed column names, enclose the computed column name in ____.

A)single quotes
B)square brackets
C)parentheses
D)curly braces
Question
A(n)____________________ column is a column that does not exist in the database but can be computed using data in the existing columns.
Question
In MySQL, to retrieve character data that exactly matches the case used in a WHERE clause, use the ____ keyword.

A)BINARY
B)EXACT
C)MATCH
D)CASE
Question
When you use the ____ function, you can use the asterisk (*)to represent any column.

A)SUM
B)COUNT
C)MAX
D)MIN
Question
The ____ clause is used to restrict the groups that are included.

A)LIKE
B)HAVING
C)WHERE
D)HAVE
Question
The ____ operator specifies a range of values in a condition.

A)LIKE
B)BETWEEN
C)DISTINCT
D)GROUP
Question
The ____ operator finds rows that do not contain a null value in the specified column

A)IS NULL
B)NOT NULL
C)!NULL
D)IS NOT NULL
Question
In MySQL, you specify the results order by using the ____________________ clause.
Question
The ____ clause lets you group data on a particular column.

A)GROUP
B)GROUP BY
C)SET GROUP
D)GROUPING
Question
When the ____________________ operator connects simple conditions, all the simple conditions must be true in order for the compound condition to be true.
Question
When you need to sort data on two columns, the less important column is called the ____ sort key.

A)double
B)primary
C)minor
D)foreign
Question
You can also assign a name to a computed column by following the computation with the word ____________________ and the desired name.
Question
You use the ____ clause to list data in a specific order.

A)ORDER
B)SET ORDER
C)ORDER BY
D)LIST BY
Question
MySQL has special functions, called ____________________ functions, to calculate sums, averages, counts, maximum values, and minimum values.
Question
When you use the MAX function, SQL ignores any ____________________ value(s)in the column and eliminates them from the computations.
Question
The inner query in a nested query is called a(n)____________________.
Question
The column on which data is to be sorted is called a sort ____________________.
Question
The ____________________ operator finds rows that contain a null value in the specified column.
Question
Describe simple and compound conditions.
Question
When you use the ____________________ function, you must specify the column to total, and the column data type must be numeric.
Question
____________________ creates groups of rows that share some common characteristic.
Question
You can use the ____________________ clause to limit the groups that are included.
Question
When you use the SUM function, the column data type must be ____________________.
Question
____________________ conditions are formed by connecting two or more simple conditions.
Question
How do you construct the SELECT query?
Question
A ____________________ query is one query inside another.
Question
When you need to sort data on two columns, the more important column is called the ____________________ sort key.
Question
Compare the WHERE and HAVING clauses.
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/75
auto play flashcards
Play
simple tutorial
Full screen (f)
exit full mode
Deck 4: Single-Table Queries
1
When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.
False
2
To specify that query results be listed in a specific order, use the SORT BY clause.
False
3
Sometimes a condition involves a column that can accept null values.
True
4
The GROUP BY clause sorts the data in a particular order.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
5
The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
6
MySQL supports only the version of the "not equal to" comparison operator.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
7
The HAVING clause is used to restrict groups.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
8
In a SELECT statement, the FROM clause and the WHERE clause (when used)must appear on separate lines.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
9
The MIN function determines the minimum value in a row.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
10
It is possible to place one query inside another.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
11
The WHERE clause applies to both rows and groups.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
12
When you query a database, there is a defined order in which the results are displayed.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
13
Aggregate functions apply to groups of rows.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
14
Preceding a condition by the NOT operator reverses the truth of the original condition.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
15
There are no special formatting rules in MySQL.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
16
You cannot assign names to computed columns.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
17
The BETWEEN operator is an essential feature of SQL.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
18
An arithmetic column is a column that does not exist in the database but can be computed using data in existing columns.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
19
All SELECT statements require a WHERE clause.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
20
You cannot change the order of the columns to be displayed in query results.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
21
The basic form of the SQL SELECT command is ____.

A)FROM-SELECT-WHERE
B)SELECT-FROM-WHERE
C)FROM-WHERE-SELECT
D)WHERE-SELECT-FROM
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
22
When data is sorted on two columns, the more important column is called the major sort key.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
23
The ____ wildcard symbol represents any individual character.

A)%
B)_
C)/
D)\
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
24
It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
25
The ____ operator is inclusive, meaning that a value equal to either value would be selected.

A)AND
B)BETWEEN
C)OR
D)NOT
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
26
After the word FROM in a SELECT statement, you list any conditions (restrictions)that apply to the data you want to retrieve.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
27
A simple condition has the form: column name, comparison operator, and then either another column name or a value.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
28
You can use computed columns in comparisons.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
29
The DISTINCT operator is useful when used in conjunction with the COUNT function.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
30
The UNIQUE operator eliminates duplicate values in a query.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
31
In SQL, the ____ symbol is used as a wildcard to represent any collection of characters.

A)*
B)%
C)?
D)!
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
32
You form compound conditions by connecting two or more simple conditions using the ____ operators.

A)AND
B)OR
C)NOT
D)All of the above
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
33
The COUNT function only applies to columns with numeric values.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
34
In a nested query, the outquery is evaluated first .
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
35
To sort records in descending order, follow the name of the sort key with the REVERSE operator.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
36
When the OR operator connects simple conditions, the compound condition will be true whenever any one of the simple conditions is true.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
37
In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.

A)\
B)/
C)*
D)?
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
38
In SQL, you use the ____ command to query a database.

A)WHERE
B)SELECT
C)FROM
D)SET
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
39
The WHERE clause is used to limit the rows that are included in a query's result.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
40
Which of the following operators can be used for a column computation?

A)+
B)^
C)**
D)All of the above
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
41
You use the ____________________ clause to retrieve rows that satisfy some condition.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
42
The ____ function calculates a total of the values in a column.

A)TOTAL
B)CALCULATE
C)SUM
D)ADD
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
43
Preceding a condition by the ____ operator reverses the truth of the original condition.

A)><
B)NOT
C)NULL
D)OR
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
44
The ____________________ operator uses one or more wildcard characters to test for a pattern match.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
45
A(n)____________________ clause provides a concise way of phrasing certain conditions.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
46
A(n)____________________ is simply a question represented in a way that the DBMS can understand.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
47
The ____ function determines the number of rows in a table.

A)ROW
B)CALCULATE
C)COUNT
D)NUMBER
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
48
To include spaces in computed column names, enclose the computed column name in ____.

A)single quotes
B)square brackets
C)parentheses
D)curly braces
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
49
A(n)____________________ column is a column that does not exist in the database but can be computed using data in the existing columns.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
50
In MySQL, to retrieve character data that exactly matches the case used in a WHERE clause, use the ____ keyword.

A)BINARY
B)EXACT
C)MATCH
D)CASE
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
51
When you use the ____ function, you can use the asterisk (*)to represent any column.

A)SUM
B)COUNT
C)MAX
D)MIN
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
52
The ____ clause is used to restrict the groups that are included.

A)LIKE
B)HAVING
C)WHERE
D)HAVE
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
53
The ____ operator specifies a range of values in a condition.

A)LIKE
B)BETWEEN
C)DISTINCT
D)GROUP
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
54
The ____ operator finds rows that do not contain a null value in the specified column

A)IS NULL
B)NOT NULL
C)!NULL
D)IS NOT NULL
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
55
In MySQL, you specify the results order by using the ____________________ clause.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
56
The ____ clause lets you group data on a particular column.

A)GROUP
B)GROUP BY
C)SET GROUP
D)GROUPING
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
57
When the ____________________ operator connects simple conditions, all the simple conditions must be true in order for the compound condition to be true.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
58
When you need to sort data on two columns, the less important column is called the ____ sort key.

A)double
B)primary
C)minor
D)foreign
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
59
You can also assign a name to a computed column by following the computation with the word ____________________ and the desired name.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
60
You use the ____ clause to list data in a specific order.

A)ORDER
B)SET ORDER
C)ORDER BY
D)LIST BY
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
61
MySQL has special functions, called ____________________ functions, to calculate sums, averages, counts, maximum values, and minimum values.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
62
When you use the MAX function, SQL ignores any ____________________ value(s)in the column and eliminates them from the computations.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
63
The inner query in a nested query is called a(n)____________________.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
64
The column on which data is to be sorted is called a sort ____________________.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
65
The ____________________ operator finds rows that contain a null value in the specified column.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
66
Describe simple and compound conditions.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
67
When you use the ____________________ function, you must specify the column to total, and the column data type must be numeric.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
68
____________________ creates groups of rows that share some common characteristic.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
69
You can use the ____________________ clause to limit the groups that are included.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
70
When you use the SUM function, the column data type must be ____________________.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
71
____________________ conditions are formed by connecting two or more simple conditions.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
72
How do you construct the SELECT query?
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
73
A ____________________ query is one query inside another.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
74
When you need to sort data on two columns, the more important column is called the ____________________ sort key.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
75
Compare the WHERE and HAVING clauses.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
locked card icon
Unlock Deck
Unlock for access to all 75 flashcards in this deck.