Chapter 2

Question 1

What is wrong with the following query?

Select FirstName, LastName
From Employees
Where PostalCode Between 98900-98911;

a. The query should end with a colon
b. The PostalCode column should be displayed after the Select keyword.
c. the query is missing a comma
d. The hyphen causes an error.

Answer 1

d. The hyphen causes an error.

The hyphen should be replaced by the AND operator.

Question 2

What keyword should you use to display columns?

a. Between
b. Where
c. Row
d. Select

Answer 2

d. Select

The select keywords is used to tell the database which columns to display.

Question 3

Which of the following is not a where clause operator?

a. IS NULL
b. AND
c. SELECT
d. =

Answer 3

c. Select

The SELECT keyword is used to tell the database which columns to display.

Question 4

Which of the following should you use to display all columns in a table?

a. Semicolon
b. Keys
c. Asterisk
d. Syntax

Answer 4

c. Asterisk

An asterisk after the SELECT keyword indicates that you want to see all of the columns displayed.

Question 5

What keyword should you use to tell the database which table to retrieve columns from?

a. WHERE
b. SYBASE
c. FROM
d. SET

Answer 5

c. From

The from keyword tells the database to look in the specified table.