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

Database Concepts 6th Edition By Kroenke – Test
Bank

Database Concepts 6th Edition By kroenke –
Test Bank
Sample Test

Database Concepts, 6e (Kroenke/Auer)
Chapter 3 Structured Query Language
1) SQL is a data sublanguage, not a complete programming language.
Answer: TRUE
Diff: 2 Page Ref: 109

2) When using SQL to create a table, a column is defined by declaring, in this order: data type, column
name, and optional constraints.
Answer: FALSE
Diff: 2 Page Ref: 115-116

3) When using SQL to create a table, specifying the NULL property for a column indicates that only null
values may be stored in that column.
Answer: FALSE
Diff: 2 Page Ref: 116

4) When using SQL to create a table, specifying a data type of Char(10) indicates a fixed length field of 10
characters.
Answer: TRUE
Diff: 1 Page Ref: 116

5) For a column to be defined as the primary key using table constraints, the column must have been given
the property NULL.
Answer: FALSE
Diff: 2 Page Ref: 118

6) If you need to create a primary key that is a composite key using SQL, the key may be defined when the
table is created using the CREATE TABLE statement.
Answer: TRUE
Diff: 3 Page Ref: 118-122

,7) Referential integrity constraints can be created using the ON DELETE phrase when the table is created
using the CREATE TABLE statement.
Answer: TRUE
Diff: 2 Page Ref: 122-124

8) Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when
the table is created using the CREATE TABLE statement.
Answer: TRUE
Diff: 2 Page Ref: 122-124

9) Data is added to a table using the SQL INSERT command.
Answer: TRUE
Diff: 1 Page Ref: 127



10) The result for SELECT statements in SQL is a relation unless the result is a single number.Answer: FALSE
Diff: 1 Page Ref: 131-133
11) 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: 133

12) In SQL, the WHERE clause is used to specify which columns will be included in the result.Answer: FALSE
Diff: 1 Page Ref: 133

13) In SQL, multiple conditions in the WHERE clause can be combined by using the SQL AND keyword.
Answer: TRUE
Diff: 1 Page Ref: 136

14) In SQL, to refer to a range in a WHERE clause, use the WITHIN keyword.
Answer: FALSE
Diff: 1 Page Ref: 137

15) 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: 137

16) In SQL, the LIKE keyword can be used to select on partial values.
Answer: TRUE
Diff: 1 Page Ref: 139

17) 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: 140

18) 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: 141

19) In SQL, the order of the rows that result from a SELECT statement can be set using the SORTBY phrase.
Answer: FALSE
Diff: 2 Page Ref: 141-143



20) The SUM built-in function in SQL is used to total the values in a numeric column.
Answer: TRUE
Diff: 1 Page Ref: 143

21) The TOP built-in function in SQL is used to find the maximum value in a numeric column.Answer: FALSE
Diff: 2 Page Ref: 143-146
22) Standard SQL does not allow built-in functions to be used in a WHERE clause.
Answer: TRUE
Diff: 3 Page Ref: 146

23) The SQL GROUP BY keyword can be used to group rows by common values.
Answer: TRUE
Diff: 2 Page Ref: 146-147

24) Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.Answer: FALSE
Diff: 2 Page Ref: 146-147

25) Data from a maximum of three tables can be combined through the use of subqueries in SQL.
Answer: FALSE
Diff: 2 Page Ref: 147-149

26) A subquery is appropriate only if the final result contains only data from a single table.Answer: TRUE
Diff: 2 Page Ref: 147-149

27) The basic idea of a join is to combine the contents of two or more relations into a new relation.Answer:
TRUE
Diff: 1 Page Ref: 149-153

28) Using standard SQL, unmatched rows will not appear in the result of a join.
Answer: TRUE
Diff: 1 Page Ref: 149-153

29) Values of existing data can be changed using SQL through the CHANGE command.
Answer: FALSE