Isds 402 Quiz 3 Chapter 3

Front 1

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?

Back 1

a. SORT BY Department REVERSE
b. SORT BY Department
c. SORT BY Department DESC
d. ORDER BY Department DESC
e. REVERSE Department

Front 2

When you connect two or more simple conditions with the AND operator, each
condition must be listed on a separate line.

Back 2

True
False

Front 3

Which of the following is not a standard data type used in SQL?

Back 3

a. Integer
b. Numeric
c. Varchar
d. Char
e. Text

Front 4

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

Back 4

a. GROUP BY
b. WHERE
c. SELECT
d. FROM
e. ORDER BY

Front 5

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

Back 5

a. DISTINCT
b. LIKE
c. SORT
d. HAVING
e. WHERE

Front 6

You must use a comma or a period to separate a table name from its alias.

Back 6

True
False

Front 7

Which of the following cannot be done using the CONSTRAINT phrase?

Back 7

a. All of these can be done using the CONSTRAINT phrase.
b. None of these can be done using the CONSTRAINT phrase.
c. Establish a referential integrity constraint.
d. Define a foreign key.
e. Create a single attribute primary key.

Front 8

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

Back 8

a. AVG
b. MAX
c. SUM
d. MODE
e. COUNT

Front 9

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

Back 9

a. SORT
b. REDUCE
c. UNIQUE
d. DISTINCT
e. ORDER BY

Front 10

To qualify a column name, precede the name of the column with the name of the table,
followed by a(n) ____.

Back 10

a. percent sign (%)
b. comma (,)
c. asterisk (*)
d. period (.)

Front 11

To open a new Microsoft Access Query window:

Back 11

a. click the New Query in Design view button on the Create command tab.
b. click the New Query button on the Home command tab.
c. click the Create Query button on the Create command tab.
d. click the Query Design button on the Command tab.
e. click the New button on the Home command tab.

Front 12

A composite primary key can be defined using the CONSTRAINT phrase in which SQL
command?

Back 12

a. CREATE TABLE
b. CHANGE TABLE
c. SET TABLE
d. MODIFY TABLE
e. BUILD TABLE

Front 13

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

Back 13

a. Both Char and VarChar
b. Numeric
c. VarChar
d. Integer
e. Char

Front 14

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

Back 14

a. ? (question mark)
b. _ (underscore)
c. % (percent sign)
d. ; (semi-colon)
e. ! (exclamation mark)

Front 15

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?

Back 15

a. WHERE Hours BETWEEN 10 AND 50
b. WHERE Hours = MIN(10) and MAX(50)
c. WHERE Hours IN [10, 50]
d. WHERE Hours = 10 and Hours = 50
e. WHERE Hours RANGE 10 TO 50

Front 16

Which of the following is not true about primary keys?

Back 16

a. Primary keys must be a single attribute.
b. Primary keys cannot be null.
c. Primary keys are used to represent relationships.
d. Primary keys must be unique.
e. Primary keys can be defined using a SQL CONSTRAINT phrase.

Front 17

The order of the columns returned by an SQL SELECT statement are determined by
the:

Back 17

a. ORDER BY clause.
b. order they are listed in following FROM.
c. order they are listed in following SELECT.
d. SORT BY clause.
e. order they are listed in following WHERE.

Front 18

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is
the standard SQL query phrase to retrieve the Name and Phone Number of customers?

Back 18

a. SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum
b. SELECT *
c. SELECT Name, PhoneNum
d. SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)
e. SELECT (Name, PhoneNum)

Front 19

In a nested query, the outer query is evaluated first.

Back 19

True
False

Front 20

A subquery is appropriate only if the final result contains only data from a single table.

Back 20

True
False

Front 21

When the OR operator connects simple conditions, the compound condition will be
true whenever any one of the simple conditions is true.

Back 21

True
False

Front 22

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?

Back 22

a. WHERE AcctBalance > 50
b. WHERE (CUSTOMER-AcctBalance > 50)
c. WHERE CUSTOMER-AcctBalance > 50
d. HAVING AcctBalance > 50
e. WHERE (AcctBalance > 50)

Front 23

It is a good idea to use a SELECT command to display the data you changed to verify
that the correct update was made.

Back 23

True
False

Front 24

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?

Back 24

a. INPUT DATA STUDENT SET StudentID=123, Name=' Jones',
Advisor='Smith';
b. INSERT DATA STUDENT SET StudentID=123, Name='Jones',
Advisor='Smith';
c. INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith');
d. INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith');
e. INPUT INTO STUDENT (123, 'Jones', 'Smith');

Front 25

You cannot assign names to computed columns.

Back 25

True
False