Deck 4: Single-Table Queries

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

Instead of including every column in the SELECT clause,you can use an ampersand (&)to indicate that you want to include all columns.​

Question 5

The WHERE clause is used to retrieve rows that satisfy some condition.​

Question 6

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

Question 7

You cannot assign names to computed columns.​

Question 8

You can use computed columns in comparisons.​

Question 9

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

Question 10

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

Question 11

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

Question 12

SQL requires that you follow special formatting rules.​

Question 13

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

Question 14

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

Question 15

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

Question 16

The BETWEEN operator is an essential feature of SQL.​

Question 17

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

Question 18

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

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

All SELECT statements require a WHERE clause.​

Question 21

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

Question 22

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 23

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

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

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

Question 28

It is possible to place one query inside another.​

Question 29

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

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

Question 30

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 31

The MIN function determines the minimum value in a column.​

Question 32

The UNIQUE operator eliminates duplicate values in a query.​

Question 33

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

Question 34

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

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

Question 35

The COUNT function only applies to columns with numeric values.​

Question 36

The WHERE clause applies to both rows and groups.​

Question 37

The HAVING clause is used to restrict groups that are included in a query result.​

Question 38

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

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

Question 39

Aggregate functions apply to groups of rows.​

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

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

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

Question 42

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

Question 43

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

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

Question 44

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

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

Question 45

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 46

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

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

Question 47

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

Question 48

The ____ wildcard symbol represents any individual character.​

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

Question 49

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

Question 50

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 51

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

Question 52

The ____ clause is used to restrict the groups that will be included in a query result.​

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

Question 53

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

Question 54

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

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

Question 55

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 56

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

Question 57

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

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

Question 58

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

Question 59

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 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

Compare the WHERE and HAVING clauses.​

Question 67

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

Question 68

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

Question 69

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

Question 70

The ____________________ operator eliminates duplicate values in the query results.​

Question 71

____________________ creates groups of rows that share some common characteristic.​

Question 72

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

Question 73

Describe simple and compound conditions.​

Question 74

How do you construct the SELECT query?​

Question 75

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