Database Concepts 8Th Edition By David M. Kroenke – Test Bank

 

 

To Purchase this Complete Test Bank with Answers Click the link Below

 

https://tbzuiqe.com/product/database-concepts-8th-edition-by-david-m-kroenke-test-bank/

 

If face any problem or Further information contact us At tbzuiqe@gmail.com

 

 

Sample Test

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

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

 

13) Standard SQL does not allow built-in functions to be used in a WHERE clause.

Answer:  TRUE

Diff: 3      Page Ref: 179

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

14) The SQL GROUP BY keyword can be used to group rows by common values.

Answer:  TRUE

Diff: 2      Page Ref: 180-181

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

15) Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.

Answer:  FALSE

Diff: 2      Page Ref: 181

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

16) The order of the columns returned by an SQL SELECT statement is determined by the ________.

1.    A) ORDER BY clause

2.    B) SORT BY clause

3.    C) order they are listed in following SELECT

4.    D) order they are listed in following WHERE

5.    E) order they are listed in following FROM

Answer:  C

Diff: 1      Page Ref: 162

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

17) Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?

1.    A) UNIQUE

2.    B) SORT

3.    C) ORDER BY

4.    D) DISTINCT

5.    E) REDUCE

Answer:  D

Diff: 2      Page Ref: 164

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

18) Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query?

1.    A) SELECT

2.    B) FROM

3.    C) WHERE

4.    D) ORDER BY

5.    E) GROUP BY

Answer:  C

Diff: 1      Page Ref: 165

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

19) Conditions after the WHERE keyword require single quotes around the values for columns that have which data type?

1.    A) Char

2.    B) Date/Time

3.    C) Integer

4.    D) Numeric

5.    E) Decimal

Answer:  A

Diff: 2      Page Ref: 232

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

20) Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column?

1.    A) WHERE Hours = MIN(10) and MAX(50)

2.    B) WHERE Hours IN [10, 50]

3.    C) WHERE Hours = 10 and Hours = 50

4.    D) WHERE Hours BETWEEN 10 AND 50

5.    E) WHERE Hours RANGE 10 TO 50

Answer:  D

Diff: 3      Page Ref: 166

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

 

21) Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character?

1.    A) % (percent sign)

2.    B) ! (exclamation mark)

3.    C) _ (underscore)

4.    D) ? (question mark)

5.    E) ; (semi-colon)

Answer:  C

Diff: 3      Page Ref: 172-173

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

22) Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?

1.    A) % (percent sign)

2.    B) ! (exclamation mark)

3.    C) _ (underscore)

4.    D) ? (question mark)

5.    E) ; (semi-colon)

Answer:  A

Diff: 3      Page Ref: 172-173

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

23) Which SQL keyword can be used in conjunction with wildcards to select partial values?

1.    A) SELECT

2.    B) SEARCH

3.    C) FIND

4.    D) SUBSTRING

5.    E) LIKE

Answer:  E

Diff: 2      Page Ref: 173

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

 

24) Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?

1.    A) SORT BY Department

2.    B) REVERSE Department

3.    C) ORDER BY Department DESC

4.    D) SORT BY Department DESC

5.    E) SORT BY Department REVERSE

Answer:  C

Diff: 2      Page Ref: 167-169

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

25) Which of the following is not one of the five SQL built-in functions?

1.    A) MODE

2.    B) SUM

3.    C) COUNT

4.    D) MAX

5.    E) AVG

Answer:  A

Diff: 1      Page Ref: 177

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

26) Given the table

 

CUSTOMER(CustID, Name, PhoneNum, AcctBalance)

 

what is the standard SQL query phrase to retrieve the Name and Phone Number of customers?

1.    A) SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum

2.    B) SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)

3.    C) SELECT Name, PhoneNum

4.    D) SELECT (Name, PhoneNum)

5.    E) SELECT *

Answer:  C

Diff: 2      Page Ref: 160

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

27) Given the table

 

CUSTOMER(CustID, Name, PhoneNum, AcctBalance)

 

what is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?

1.    A) WHERE CUSTOMER-AcctBalance > 50

2.    B) WHERE (CUSTOMER-AcctBalance > 50)

3.    C) WHERE AcctBalance > 50

4.    D) WHERE (AcctBalance > 50)

5.    E) HAVING AcctBalance > 50

Answer:  C

Diff: 2      Page Ref: 165-166

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

28) Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

1.    A) WHERE

2.    B) HAVING

3.    C) LIKE

4.    D) SORT

5.    E) DISTINCT

Answer:  B

Diff: 3      Page Ref: 182

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

29) Microsoft Access SQL commands are run in ________.

1.    A) the SQL window

2.    B) the QBE window

3.    C) the Query View of an SQL window

4.    D) the Design View of a Query window

5.    E) the SQL View of a Query window

Answer:  E

Diff: 2      Page Ref: 202

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

 

30) One way to specify all of the columns of a table is to use the special character * after the SQL keyword ________.

Answer:  SELECT

Diff: 1      Page Ref: 161

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

31) Conditions in an SQL INSERT command and after the SQL ________ keyword require single quotes around values for Char and VarChar columns, but not around values for Integer and Numeric columns.

Answer:  WHERE

Diff: 3      Page Ref: 165

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

32) Given the table

 

CUSTOMER(CustID, Name, PhoneNumber, AccountBalance)

 

write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Answer:           SELECT Name, PhoneNumber

FROM CUSTOMER

WHERE AccountBalance > 50;

Diff: 2      Page Ref: 160-165

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

33) Given the table

 

CUSTOMER(CustID, Name, PhoneNumber, AccountBalance)

 

write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with ‘S’.

Answer:           SELECT Name, PhoneNumber

FROM CUSTOMER

WHERE Name LIKE ‘S%’;

Diff: 2      Page Ref: 160-165

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

 

34) What are SQL Built-in Functions?

Answer:  SQL Built-in Functions are functions that manipulate the results of an SQL SELECT statement. The built-in functions for standard SQL are COUNT, SUM, AVG, MAX, and MIN. The COUNT function counts the number of rows in the result. The SUM function totals the values in a number-oriented field. The AVG function calculates the mean of the values in a number-oriented field. The MAX function determines the highest value, and the MIN function determines the lowest value, in a number-oriented field.

Diff: 2      Page Ref: 176-178

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

35) Distinguish between the HAVING clause and the WHERE clause.

Answer:  The HAVING clause and the WHERE clause differ in that the WHERE clause is used to identify rows that satisfy a stated condition. The HAVING clause is used to identify groups which have been created by the GROUP BY clause and that satisfy a stated condition. In cases when the WHERE clause and the HAVING clause are both allowed to appear in the same SELECT statement, the WHERE clause is generally implemented to execute before the HAVING clause.

Diff: 3      Page Ref: 182

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements and options for processing a single table

Classification:  Concept

 

36) Data is added to a table using the SQL INSERT command.

Answer:  TRUE

Diff: 1      Page Ref: 153

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for adding to a database

Classification:  Concept

 

37) Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table?

1.    A) INSERT DATA STUDENT SET StudentID=123, Name=’Jones’, Advisor=’Smith’;

2.    B) INSERT INTO STUDENT VALUES (123, ‘Jones’, ‘Smith’);

3.    C) INSERT INTO STUDENT (New Student Data) VALUES (123, ‘Jones’, ‘Smith’);

4.    D) INPUT DATA STUDENT SET StudentID=123, Name=’ Jones’, Advisor=’Smith’;

5.    E) INPUT INTO STUDENT (123, ‘Jones’, ‘Smith’);

Answer:  B

Diff: 3      Page Ref: 155-156

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for adding to a database

Classification:  Concept

 

 

38) To open a new Microsoft Access Query window ________.

1.    A) click the New button on the Home command tab

2.    B) click the New Query button on the Home command tab

3.    C) click the Create Query button on the Create command tab

4.    D) click the New Query in Design view button on the Create command tab

5.    E) click the Query Design button on the Command tab

Answer:  E

Diff: 2      Page Ref: 202

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for adding to a database

Classification:  Concept

39) In Microsoft Access, tables are added to a Query window by ________.

1.    A) selecting the tables from the Use Table dialog box

2.    B) selecting the tables from the Show Table dialog box

3.    C) selecting the tables from the Tables section of the Navigation Pane

4.    D) selecting the tables from the Queries section of the Navigation Pane

5.    E) selecting the tables from the Relationships window

Answer:  B

Diff: 3      Page Ref: 203

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for adding to a database

Classification:  Concept

 

40) The SQL command used to add new data to a table is ________.

Answer:  INSERT

Diff: 1      Page Ref: 155

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for adding to a database

Classification:  Concept

 

41) SQL is a data sublanguage, not a complete programming language.

Answer:  TRUE

Diff: 2      Page Ref: 133

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for creating database structures

Classification:  Concept

 

42) 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: 142

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for creating database structures

Classification:  Concept

 

 

43) 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: 143

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for creating database structures

Classification:  Concept

 

44) 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: 143

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for creating database structures

Classification:  Concept

45) 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: 149

AACSB:  Information Technology

Chapter Obj:  Learn basic SQL statements for creating database structures

Classification:  Concept