Ch 6 Quiz - Database Management and Design

Which of the following is not a comparison operator used in the Where clause?

!=

The maximum number of clauses in an SQL Select statement is ______. (digital number)

6

The meaning of Month in Month(SaleDate) is:

A function that returns the number of the month in the date

Numeric literal values are always represented

As is, with no special punctuation

To sort the result in reverse alphabetical order you use the abbreviated word _______.

Desc

To eliminate duplicate values you put into the Select clause the key word

Distinct

SQL is only used for "querying" the database to retrieve data.

False

The order in which the four SQL query clauses are executed is _____ _____ _____ ______. (separate answers with commas.)

From, Where, Select, Order by

* in an SQL Select statement means:

List all columns

The order of precedence for AND, OR, and NOT is _____ _____ _____. (include commas to separate words)

NOT, AND, OR

To sort the result in alphabetical order you use the key word

No key word is needed

To override precedence of AND, OR, and NOT, use:

Parentheses

A query that accesses a single table is called a(n) ______ query.

Simple

The SQL statement used to change data in an existing row is Alter.

False

The SQL statement used to enter new rows into a table is Append.

False

The clause that identifies the tables the query should access is Select.

False

The clause that says which columns to list in the query result is Order by.

False

The maximum number of tables that can be joined in an SQL Select statement is 8.

False

The From clause can contain a second name for a table which references the same table.

True

The default sort order of a query result is ascending by the first column in the Order by clause.

True

A column whose value is always unique in a table is called

a key

The From clause can contain a second name for a table. This name is called a(n) ______.

alias

Conditions connected by OR will be true only when _____ are true (both/either/neither)

either

The process of linking records in different tables is called _______ the tables.

joining

String literal values are always represented in ______ ______.

single quotes