Deck 4: Single-Table Queries

Question 1

SQL requires that you follow special formatting rules.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

All SELECT statements require a WHERE clause.

Question 5

Oracle supports only the <> version of the "not equal to" comparison operator.

Question 6

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

Question 7

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

Question 8

The BETWEEN operator is an essential feature of SQL.

Question 9

You can use computed columns in comparisons.

Question 10

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

Question 11

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

Question 12

You cannot assign names to computed columns.

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

A query is a question represented in a way that the DBMS can understand.

Question 21

The MIN function determines the minimum value in a column.

Question 22

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

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

Question 23

The COUNT function only applies to columns with numeric values.

Question 24

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 25

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

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

Question 26

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

Question 27

The WHERE clause applies to both rows and groups.

Question 28

You form compound conditions by connecting two or more simple conditions using the ____ operator.

A) AND
B) OR
C) NOT
D) All of the above

Question 29

In a nested query, the outer query is evaluated first.

Question 30

The UNIQUE operator eliminates duplicate values in a query.

Question 31

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

Question 32

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

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

Question 33

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

Question 34

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

Question 35

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

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

Question 36

The HAVING clause is used to restrict groups.

Question 37

Aggregate functions apply to groups of rows.

Question 38

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

A) REVERSE
B) NOT
C) NULL
D) OR

Question 39

It is possible to place one query inside another.

Question 40

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

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

Question 41

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

Question 42

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

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

Question 43

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 44

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

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

Question 45

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

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

Question 46

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

Question 47

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

Question 48

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 49

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

Question 50

You can use the ____ operator followed by a collection of values to provide a concise way of phrasing certain conditions.

A) LIKE
B) CONTAIN
C) VALUES
D) IN

Question 51

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

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

Question 52

The ____ wildcard symbol represents any individual character.

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

Question 53

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

Question 54

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

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

Question 55

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

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

Question 56

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

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

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

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

Question 59

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

A) PATTERN
B) LIKE
C) MATCH
D) SIMILAR

Question 60

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

Question 61

How do you construct the SELECT query?

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

Describe simple and compound conditions.

Question 70

Compare the WHERE and HAVING clauses.

Question 71

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

Question 72

The ____________________ operator eliminates duplicate values in the query results.

Question 73

____________________ creates groups of rows that share some common characteristic.

Question 74

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

Question 75

In SQL, you specify the order of data in query results by using the ____________________ clause.