Database Concepts 8Th Ed By David M.
Kroenke – Test Bank
Database Concepts 8Th Ed By David M. Kroenke – Test Bank
Database Concepts, 8e (Kroenke)
Chapter 3 Structured Query Language
1) The result for SELECT statements in SQL is a relation unless the result is a single number.
Answer: FALSE
Diff: 1 Page Ref: 160
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
2) To force the DBMS to remove duplicate rows from the results of an SQL SELECT query, the
keyword DISTINCT must be used.
Answer: TRUE
Diff: 2 Page Ref: 164
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
3) In SQL, the WHERE clause is used to specify which columns will be included in the result.
Answer: FALSE
,Diff: 1 Page Ref: 165
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
4) In SQL, multiple conditions in the WHERE clause can be combined by using the SQL AND
keyword.
Answer: TRUE
Diff: 1 Page Ref: 169
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
5) In SQL, to refer to a range of values in a WHERE clause, use the WITHIN keyword.
Answer: FALSE
Diff: 1 Page Ref: 172
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
6) In SQL, the NOT keyword can be combined with the IN keyword to form the NOT IN
condition for selecting values.
Answer: TRUE
Diff: 1 Page Ref: 171
,AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
7) In SQL, the LIKE keyword can be used to select on partial values.
Answer: TRUE
Diff: 1 Page Ref: 172-173
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
8) In SQL, the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE
condition for selecting values.
Answer: TRUE
Diff: 1 Page Ref: 172
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
9) In SQL, the IS NULL keyword can be used to select on records containing NULL values in a
particular column.
Answer: TRUE
Diff: 1 Page Ref: 175-176
AACSB: Information Technology
, Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
10) In SQL, the order of the rows that result from a SELECT statement can be set using the SORT
BY phrase.
Answer: FALSE
Diff: 2 Page Ref: 167-169
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
11) The SUM built-in function in SQL is used to total the values in a numeric column.
Answer: TRUE
Diff: 1 Page Ref: 177
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
12) The TOP built-in function in SQL is used to find the maximum value in a numeric column.
Answer: FALSE
Diff: 2 Page Ref: 177
AACSB: Information Technology
Kroenke – Test Bank
Database Concepts 8Th Ed By David M. Kroenke – Test Bank
Database Concepts, 8e (Kroenke)
Chapter 3 Structured Query Language
1) The result for SELECT statements in SQL is a relation unless the result is a single number.
Answer: FALSE
Diff: 1 Page Ref: 160
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
2) To force the DBMS to remove duplicate rows from the results of an SQL SELECT query, the
keyword DISTINCT must be used.
Answer: TRUE
Diff: 2 Page Ref: 164
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
3) In SQL, the WHERE clause is used to specify which columns will be included in the result.
Answer: FALSE
,Diff: 1 Page Ref: 165
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
4) In SQL, multiple conditions in the WHERE clause can be combined by using the SQL AND
keyword.
Answer: TRUE
Diff: 1 Page Ref: 169
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
5) In SQL, to refer to a range of values in a WHERE clause, use the WITHIN keyword.
Answer: FALSE
Diff: 1 Page Ref: 172
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
6) In SQL, the NOT keyword can be combined with the IN keyword to form the NOT IN
condition for selecting values.
Answer: TRUE
Diff: 1 Page Ref: 171
,AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
7) In SQL, the LIKE keyword can be used to select on partial values.
Answer: TRUE
Diff: 1 Page Ref: 172-173
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
8) In SQL, the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE
condition for selecting values.
Answer: TRUE
Diff: 1 Page Ref: 172
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
9) In SQL, the IS NULL keyword can be used to select on records containing NULL values in a
particular column.
Answer: TRUE
Diff: 1 Page Ref: 175-176
AACSB: Information Technology
, Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
10) In SQL, the order of the rows that result from a SELECT statement can be set using the SORT
BY phrase.
Answer: FALSE
Diff: 2 Page Ref: 167-169
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
11) The SUM built-in function in SQL is used to total the values in a numeric column.
Answer: TRUE
Diff: 1 Page Ref: 177
AACSB: Information Technology
Chapter Obj: Learn basic SQL statements and options for processing a single table
Classification: Concept
12) The TOP built-in function in SQL is used to find the maximum value in a numeric column.
Answer: FALSE
Diff: 2 Page Ref: 177
AACSB: Information Technology
