Deck 4: Single-Table Queries

Question 1

When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.

Answer 1

False

Question 2

To specify that query results be listed in a specific order, use the SORT BY clause.

Answer 2

False

Question 3

Sometimes a condition involves a column that can accept null values.

Answer 3

True

Question 4

The GROUP BY clause sorts the data in a particular order.

Question 5

The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.

Question 6

MySQL supports only the version of the "not equal to" comparison operator.

Question 7

The HAVING clause is used to restrict groups.

Question 8

In a SELECT statement, the FROM clause and the WHERE clause (when used)must appear on separate lines.

Question 9

The MIN function determines the minimum value in a row.

Question 10

It is possible to place one query inside another.

Question 11

The WHERE clause applies to both rows and groups.

Question 12

When you query a database, there is a defined order in which the results are displayed.

Question 13

Aggregate functions apply to groups of rows.

Question 14

Preceding a condition by the NOT operator reverses the truth of the original condition.

Question 15

There are no special formatting rules in MySQL.

Question 16

You cannot assign names to computed columns.

Question 17

The BETWEEN operator is an essential feature of SQL.

Question 18

An arithmetic column is a column that does not exist in the database but can be computed using data in existing columns.

Question 19

All SELECT statements require a WHERE clause.

Question 20

You cannot change the order of the columns to be displayed in query results.

Question 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

Question 22

When data is sorted on two columns, the more important column is called the major sort key.

Question 23

The ____ wildcard symbol represents any individual character.

A)%
B)_
C)/
D)\

Question 24

It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.

Question 25

The ____ operator is inclusive, meaning that a value equal to either value would be selected.

A)AND
B)BETWEEN
C)OR
D)NOT

Question 26

After the word FROM in a SELECT statement, you list any conditions (restrictions)that apply to the data you want to retrieve.

Question 27

A simple condition has the form: column name, comparison operator, and then either another column name or a value.

Question 28

You can use computed columns in comparisons.

Question 29

The DISTINCT operator is useful when used in conjunction with the COUNT function.

Question 30

The UNIQUE operator eliminates duplicate values in a query.

Question 31

In SQL, the ____ symbol is used as a wildcard to represent any collection of characters.

A)*
B)%
C)?
D)!

Question 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

Question 33

The COUNT function only applies to columns with numeric values.

Question 34

In a nested query, the outquery is evaluated first .

Question 35

To sort records in descending order, follow the name of the sort key with the REVERSE operator.

Question 36

When the OR operator connects simple conditions, the compound condition will be true whenever any one of the simple conditions is true.

Question 37

In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.

A)\
B)/
C)*
D)?

Question 38

In SQL, you use the ____ command to query a database.

A)WHERE
B)SELECT
C)FROM
D)SET

Question 39

The WHERE clause is used to limit the rows that are included in a query's result.

Question 40

Which of the following operators can be used for a column computation?

A)+
B)^
C)**
D)All of the above

Question 41

You use the ____________________ clause to retrieve rows that satisfy some condition.

Question 42

The ____ function calculates a total of the values in a column.

A)TOTAL
B)CALCULATE
C)SUM
D)ADD

Question 43

Preceding a condition by the ____ operator reverses the truth of the original condition.

A)><
B)NOT
C)NULL
D)OR

Question 44

The ____________________ operator uses one or more wildcard characters to test for a pattern match.

Question 45

A(n)____________________ clause provides a concise way of phrasing certain conditions.

Question 46

A(n)____________________ is simply a question represented in a way that the DBMS can understand.

Question 47

The ____ function determines the number of rows in a table.

A)ROW
B)CALCULATE
C)COUNT
D)NUMBER

Question 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

Question 49

A(n)____________________ column is a column that does not exist in the database but can be computed using data in the existing columns.

Question 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

Question 51

When you use the ____ function, you can use the asterisk (*)to represent any column.

A)SUM
B)COUNT
C)MAX
D)MIN

Question 52

The ____ clause is used to restrict the groups that are included.

A)LIKE
B)HAVING
C)WHERE
D)HAVE

Question 53

The ____ operator specifies a range of values in a condition.

A)LIKE
B)BETWEEN
C)DISTINCT
D)GROUP

Question 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

Question 55

In MySQL, you specify the results order by using the ____________________ clause.

Question 56

The ____ clause lets you group data on a particular column.

A)GROUP
B)GROUP BY
C)SET GROUP
D)GROUPING

Question 57

When the ____________________ operator connects simple conditions, all the simple conditions must be true in order for the compound condition to be true.

Question 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

Question 59

You can also assign a name to a computed column by following the computation with the word ____________________ and the desired name.

Question 60

You use the ____ clause to list data in a specific order.

A)ORDER
B)SET ORDER
C)ORDER BY
D)LIST BY

Question 61

MySQL has special functions, called ____________________ functions, to calculate sums, averages, counts, maximum values, and minimum values.

Question 62

When you use the MAX function, SQL ignores any ____________________ value(s)in the column and eliminates them from the computations.

Question 63

The inner query in a nested query is called a(n)____________________.

Question 64

The column on which data is to be sorted is called a sort ____________________.

Question 65

The ____________________ operator finds rows that contain a null value in the specified column.

Question 66

Describe simple and compound conditions.

Question 67

When you use the ____________________ function, you must specify the column to total, and the column data type must be numeric.

Question 68

____________________ creates groups of rows that share some common characteristic.

Question 69

You can use the ____________________ clause to limit the groups that are included.

Question 70

When you use the SUM function, the column data type must be ____________________.

Question 71

____________________ conditions are formed by connecting two or more simple conditions.

Question 72

How do you construct the SELECT query?

Question 73

A ____________________ query is one query inside another.

Question 74

When you need to sort data on two columns, the more important column is called the ____________________ sort key.

Question 75

Compare the WHERE and HAVING clauses.