Database Concepts, Kroenke 8TH EDITION- Complete test bank -

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