DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and
Implementation 15th Edition Kroenke
Database Processing, 15e (Kroenke)
Chapter 2: Introduction to Structured Query Language
1) Business Intelligence (BI) systems typically store their data in data warehouses.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To understand the use of extracted data sets in business intelligence (BI) systems
Classification: Concept
2) An ad-hoc SQL query is typically written within an application program.
Answer: FALSE
AACSB: Information Technology
Difficulty: Moderate
LO: To understand the use of ad-hoc queries in business intelligence (BI) systems
Classification: Concept
3) SQL stands for Standard Query Language.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept
4) SQL includes a data definition language, a data manipulation language, and SQL/Persistent
stored modules.
Answer: TRUE
AACSB: Information Technology
Difficulty: Moderate
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept
5) SQL is only a data manipulation language (DML).
Answer: FALSE
AACSB: Information Technology
Difficulty: Difficult
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept
6) The American National Standards Institute (ANSI) maintains the standards for SQL.
Answer: TRUE
AACSB: Information Technology
Difficulty: Difficult
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept
1
Copyright © 2019 Pearson Education, Inc.
mynursytest.store
,DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and
Implementation 15th Edition Kroenke Implementation 15th Edition Kroenke
7) SQL was developed by IBM in the late 1970s. 13) The SQL keyword WHERE is used to specify the table(s) that contain(s) the data to be
Answer: TRUE retrieved.
AACSB: Information Technology Answer: FALSE
Difficulty: Easy AACSB: Information Technology
LO: To understand the history and significance of Structured Query Language (SQL) Difficulty: Easy
Classification: Concept LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
queries
8) SQL is not a complete programming language. Rather it is a data sublanguage. Classification: Concept
Answer: TRUE
AACSB: Information Technology 14) The SQL keyword FROM is used to specify the table to be used.
Difficulty: Moderate Answer: TRUE
LO: To understand the history and significance of Structured Query Language (SQL) AACSB: Information Technology
Classification: Concept Difficulty: Easy
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
9) In addition to being a data sublanguage, SQL is also a programming language, like Java or C#. queries
Answer: FALSE Classification: Concept
AACSB: Information Technology
Difficulty: Moderate 15) SQL can only query a single table.
LO: To understand the history and significance of Structured Query Language (SQL) Answer: FALSE
Classification: Concept AACSB: Information Technology
Difficulty: Moderate
10) SQL commands can be embedded in application programs. LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
Answer: TRUE queries
AACSB: Information Technology Classification: Concept
Difficulty: Difficult
LO: To understand the history and significance of Structured Query Language (SQL) 16) SQL statements end with a colon.
Classification: Concept Answer: FALSE
AACSB: Information Technology
11) SQL, although very popular, has never become a national standard. Difficulty: Easy
Answer: FALSE LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
AACSB: Information Technology queries
Difficulty: Moderate Classification: Concept
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept 17) The columns to be obtained by an SQL command are listed after the FROM keyword.
Answer: FALSE
12) The SQL keyword SELECT is used to specify the columns to be listed in the query results. AACSB: Information Technology
Answer: TRUE Difficulty: Moderate
AACSB: Information Technology LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
Difficulty: Moderate queries
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 18) To remove duplicate rows from the result of a query, specify the DISTINCT keyword.
Answer: TRUE
AACSB: Information Technology
Difficulty: Difficult
LO: To create SQL queries that use the SQL DISTINCT, TOP, and TOP PERCENT keywords
Classification: Concept
2 3
Copyright © 2019 Pearson Education, Inc. Copyright © 2019 Pearson Education, Inc.
mynursytest.store mynursytest.store
,DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and
Implementation 15th Edition Kroenke Implementation 15th Edition Kroenke
24) The WHERE clause contains the condition that specifies which columns are to be selected.
19) To obtain all columns, use an asterisk (*) wildcard character instead of listing all the column Answer: FALSE
names. AACSB: Information Technology
Answer: TRUE Difficulty: Moderate
AACSB: Information Technology LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
Difficulty: Easy queries
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 25) The rows of the result table can be sorted by the values in one or more columns.
Answer: TRUE
20) The WHERE clause contains the condition that specifies which rows are to be selected. AACSB: Information Technology
Answer: TRUE Difficulty: Easy
AACSB: Information Technology LO: To create SQL queries that use the SQL SELECT, FROM, WHERE, ORDER BY, GROUP
Difficulty: Easy BY, and HAVING clauses
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 26) Sorting is specified using the SORT BY phrase.
Answer: FALSE
21) The result of an SELECT operation can contain duplicate rows. AACSB: Information Technology
Answer: TRUE Difficulty: Easy
AACSB: Information Technology LO: To create SQL queries that use the SQL SELECT, FROM, WHERE, ORDER BY, GROUP
Difficulty: Moderate BY, and HAVING clauses
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 27) To sort the rows of the result table, the ORDER BY clause is specified.
Answer: TRUE
22) To have SQL automatically eliminate duplicate rows from a result, use the keyword AACSB: Information Technology
DISTINCT with the FROM keyword. Difficulty: Moderate
Answer: FALSE LO: To create SQL queries that use the SQL SELECT, FROM, WHERE, ORDER BY, GROUP
AACSB: Information Technology; Application of Knowledge BY, and HAVING clauses
Difficulty: Difficult Classification: Concept
LO: To create SQL queries that use the SQL DISTINCT, TOP, and TOP PERCENT keywords
Classification: Concept 28) Columns can be sorted in descending sequence by using the DESC keyword.
Answer: TRUE
23) An asterisk (*) following the SELECT verb means that all columns are to be displayed. AACSB: Information Technology
Answer: TRUE Difficulty: Moderate
AACSB: Information Technology LO: To create SQL queries that use the SQL SELECT, FROM, WHERE, ORDER BY, GROUP
Difficulty: Moderate BY, and HAVING clauses
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 29) A WHERE clause can contain only one condition.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
queries
Classification: Concept
4 5
Copyright © 2019 Pearson Education, Inc. Copyright © 2019 Pearson Education, Inc.
mynursytest.store mynursytest.store
, DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and
Implementation 15th Edition Kroenke Implementation 15th Edition Kroenke
30) When two conditions must both be true for the rows to be selected, the conditions are 35) The SQL keyword LIKE is used in SQL expressions to select partial string values.
separated by the SQL AND keyword. Answer: TRUE
Answer: TRUE AACSB: Information Technology; Application of Knowledge
AACSB: Information Technology; Application of Knowledge Difficulty: Moderate
Difficulty: Easy LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
LO: To create SQL queries that use the SQL logical operators including AND, OR, and NOT LIKE, IN, and IS NULL
Classification: Concept Classification: Concept
31) To refer to a set of values needed for a condition, use the IN operator. 36) The SQL wildcard character "%" represents a series of one or more unspecified characters.
Answer: TRUE Answer: TRUE
AACSB: Information Technology; Application of Knowledge AACSB: Information Technology; Application of Knowledge
Difficulty: Difficult Difficulty: Difficult
LO: To create SQL queries that use the SQL comparison operators including BETWEEN, LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
LIKE, IN, and IS NULL LIKE, IN, and IS NULL
Classification: Concept Classification: Concept
32) To exclude one or more values using a condition, the OUT keyword must be used. 37) The wildcard character "#" indicates a single, unspecified character.
Answer: FALSE Answer: FALSE
AACSB: Information Technology AACSB: Information Technology
Difficulty: Difficult Difficulty: Difficult
LO: To create SQL queries that use the SQL comparison operators including BETWEEN, LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
LIKE, IN, and IS NULL LIKE, IN, and IS NULL
Classification: Concept Classification: Concept
33) To refer to a set of values in a condition, the values are placed inside parentheses () and 38) The Microsoft Access wildcard character "*" (asterisk) indicates a sequence of one or more
separated by commas. unspecified characters in a Microsoft Access SQL query.
Answer: TRUE Answer: FALSE
AACSB: Information Technology AACSB: Information Technology; Application of Knowledge
Difficulty: Difficult Difficulty: Difficult
LO: To create SQL queries that use the SQL comparison operators including BETWEEN, LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
LIKE, IN, and IS NULL LIKE, IN, and IS NULL
Classification: Concept Classification: Concept
34) The condition in WHERE clauses can refer to a set of values by using the IN operator. 39) The Microsoft Access wildcard character "_" (underscore) indicates a single, unspecified
Answer: TRUE character in a specific location in a Microsoft Access SQL query.
AACSB: Information Technology; Application of Knowledge Answer: FALSE
Difficulty: Moderate AACSB: Information Technology
LO: To create SQL queries that use the SQL comparison operators including BETWEEN, Difficulty: Difficult
LIKE, IN, and IS NULL LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
Classification: Concept LIKE, IN, and IS NULL
Classification: Concept
6 7
Copyright © 2019 Pearson Education, Inc. Copyright © 2019 Pearson Education, Inc.
mynursytest.store mynursytest.store
Implementation 15th Edition Kroenke
Database Processing, 15e (Kroenke)
Chapter 2: Introduction to Structured Query Language
1) Business Intelligence (BI) systems typically store their data in data warehouses.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To understand the use of extracted data sets in business intelligence (BI) systems
Classification: Concept
2) An ad-hoc SQL query is typically written within an application program.
Answer: FALSE
AACSB: Information Technology
Difficulty: Moderate
LO: To understand the use of ad-hoc queries in business intelligence (BI) systems
Classification: Concept
3) SQL stands for Standard Query Language.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept
4) SQL includes a data definition language, a data manipulation language, and SQL/Persistent
stored modules.
Answer: TRUE
AACSB: Information Technology
Difficulty: Moderate
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept
5) SQL is only a data manipulation language (DML).
Answer: FALSE
AACSB: Information Technology
Difficulty: Difficult
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept
6) The American National Standards Institute (ANSI) maintains the standards for SQL.
Answer: TRUE
AACSB: Information Technology
Difficulty: Difficult
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept
1
Copyright © 2019 Pearson Education, Inc.
mynursytest.store
,DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and
Implementation 15th Edition Kroenke Implementation 15th Edition Kroenke
7) SQL was developed by IBM in the late 1970s. 13) The SQL keyword WHERE is used to specify the table(s) that contain(s) the data to be
Answer: TRUE retrieved.
AACSB: Information Technology Answer: FALSE
Difficulty: Easy AACSB: Information Technology
LO: To understand the history and significance of Structured Query Language (SQL) Difficulty: Easy
Classification: Concept LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
queries
8) SQL is not a complete programming language. Rather it is a data sublanguage. Classification: Concept
Answer: TRUE
AACSB: Information Technology 14) The SQL keyword FROM is used to specify the table to be used.
Difficulty: Moderate Answer: TRUE
LO: To understand the history and significance of Structured Query Language (SQL) AACSB: Information Technology
Classification: Concept Difficulty: Easy
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
9) In addition to being a data sublanguage, SQL is also a programming language, like Java or C#. queries
Answer: FALSE Classification: Concept
AACSB: Information Technology
Difficulty: Moderate 15) SQL can only query a single table.
LO: To understand the history and significance of Structured Query Language (SQL) Answer: FALSE
Classification: Concept AACSB: Information Technology
Difficulty: Moderate
10) SQL commands can be embedded in application programs. LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
Answer: TRUE queries
AACSB: Information Technology Classification: Concept
Difficulty: Difficult
LO: To understand the history and significance of Structured Query Language (SQL) 16) SQL statements end with a colon.
Classification: Concept Answer: FALSE
AACSB: Information Technology
11) SQL, although very popular, has never become a national standard. Difficulty: Easy
Answer: FALSE LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
AACSB: Information Technology queries
Difficulty: Moderate Classification: Concept
LO: To understand the history and significance of Structured Query Language (SQL)
Classification: Concept 17) The columns to be obtained by an SQL command are listed after the FROM keyword.
Answer: FALSE
12) The SQL keyword SELECT is used to specify the columns to be listed in the query results. AACSB: Information Technology
Answer: TRUE Difficulty: Moderate
AACSB: Information Technology LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
Difficulty: Moderate queries
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 18) To remove duplicate rows from the result of a query, specify the DISTINCT keyword.
Answer: TRUE
AACSB: Information Technology
Difficulty: Difficult
LO: To create SQL queries that use the SQL DISTINCT, TOP, and TOP PERCENT keywords
Classification: Concept
2 3
Copyright © 2019 Pearson Education, Inc. Copyright © 2019 Pearson Education, Inc.
mynursytest.store mynursytest.store
,DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and
Implementation 15th Edition Kroenke Implementation 15th Edition Kroenke
24) The WHERE clause contains the condition that specifies which columns are to be selected.
19) To obtain all columns, use an asterisk (*) wildcard character instead of listing all the column Answer: FALSE
names. AACSB: Information Technology
Answer: TRUE Difficulty: Moderate
AACSB: Information Technology LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
Difficulty: Easy queries
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 25) The rows of the result table can be sorted by the values in one or more columns.
Answer: TRUE
20) The WHERE clause contains the condition that specifies which rows are to be selected. AACSB: Information Technology
Answer: TRUE Difficulty: Easy
AACSB: Information Technology LO: To create SQL queries that use the SQL SELECT, FROM, WHERE, ORDER BY, GROUP
Difficulty: Easy BY, and HAVING clauses
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 26) Sorting is specified using the SORT BY phrase.
Answer: FALSE
21) The result of an SELECT operation can contain duplicate rows. AACSB: Information Technology
Answer: TRUE Difficulty: Easy
AACSB: Information Technology LO: To create SQL queries that use the SQL SELECT, FROM, WHERE, ORDER BY, GROUP
Difficulty: Moderate BY, and HAVING clauses
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 27) To sort the rows of the result table, the ORDER BY clause is specified.
Answer: TRUE
22) To have SQL automatically eliminate duplicate rows from a result, use the keyword AACSB: Information Technology
DISTINCT with the FROM keyword. Difficulty: Moderate
Answer: FALSE LO: To create SQL queries that use the SQL SELECT, FROM, WHERE, ORDER BY, GROUP
AACSB: Information Technology; Application of Knowledge BY, and HAVING clauses
Difficulty: Difficult Classification: Concept
LO: To create SQL queries that use the SQL DISTINCT, TOP, and TOP PERCENT keywords
Classification: Concept 28) Columns can be sorted in descending sequence by using the DESC keyword.
Answer: TRUE
23) An asterisk (*) following the SELECT verb means that all columns are to be displayed. AACSB: Information Technology
Answer: TRUE Difficulty: Moderate
AACSB: Information Technology LO: To create SQL queries that use the SQL SELECT, FROM, WHERE, ORDER BY, GROUP
Difficulty: Moderate BY, and HAVING clauses
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database Classification: Concept
queries
Classification: Concept 29) A WHERE clause can contain only one condition.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
LO: To understand the SQL SELECT/FROM/WHERE framework as the basis for database
queries
Classification: Concept
4 5
Copyright © 2019 Pearson Education, Inc. Copyright © 2019 Pearson Education, Inc.
mynursytest.store mynursytest.store
, DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and
Implementation 15th Edition Kroenke Implementation 15th Edition Kroenke
30) When two conditions must both be true for the rows to be selected, the conditions are 35) The SQL keyword LIKE is used in SQL expressions to select partial string values.
separated by the SQL AND keyword. Answer: TRUE
Answer: TRUE AACSB: Information Technology; Application of Knowledge
AACSB: Information Technology; Application of Knowledge Difficulty: Moderate
Difficulty: Easy LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
LO: To create SQL queries that use the SQL logical operators including AND, OR, and NOT LIKE, IN, and IS NULL
Classification: Concept Classification: Concept
31) To refer to a set of values needed for a condition, use the IN operator. 36) The SQL wildcard character "%" represents a series of one or more unspecified characters.
Answer: TRUE Answer: TRUE
AACSB: Information Technology; Application of Knowledge AACSB: Information Technology; Application of Knowledge
Difficulty: Difficult Difficulty: Difficult
LO: To create SQL queries that use the SQL comparison operators including BETWEEN, LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
LIKE, IN, and IS NULL LIKE, IN, and IS NULL
Classification: Concept Classification: Concept
32) To exclude one or more values using a condition, the OUT keyword must be used. 37) The wildcard character "#" indicates a single, unspecified character.
Answer: FALSE Answer: FALSE
AACSB: Information Technology AACSB: Information Technology
Difficulty: Difficult Difficulty: Difficult
LO: To create SQL queries that use the SQL comparison operators including BETWEEN, LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
LIKE, IN, and IS NULL LIKE, IN, and IS NULL
Classification: Concept Classification: Concept
33) To refer to a set of values in a condition, the values are placed inside parentheses () and 38) The Microsoft Access wildcard character "*" (asterisk) indicates a sequence of one or more
separated by commas. unspecified characters in a Microsoft Access SQL query.
Answer: TRUE Answer: FALSE
AACSB: Information Technology AACSB: Information Technology; Application of Knowledge
Difficulty: Difficult Difficulty: Difficult
LO: To create SQL queries that use the SQL comparison operators including BETWEEN, LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
LIKE, IN, and IS NULL LIKE, IN, and IS NULL
Classification: Concept Classification: Concept
34) The condition in WHERE clauses can refer to a set of values by using the IN operator. 39) The Microsoft Access wildcard character "_" (underscore) indicates a single, unspecified
Answer: TRUE character in a specific location in a Microsoft Access SQL query.
AACSB: Information Technology; Application of Knowledge Answer: FALSE
Difficulty: Moderate AACSB: Information Technology
LO: To create SQL queries that use the SQL comparison operators including BETWEEN, Difficulty: Difficult
LIKE, IN, and IS NULL LO: To create SQL queries that use the SQL comparison operators including BETWEEN,
Classification: Concept LIKE, IN, and IS NULL
Classification: Concept
6 7
Copyright © 2019 Pearson Education, Inc. Copyright © 2019 Pearson Education, Inc.
mynursytest.store mynursytest.store
