Chapter 6.1-6.3 Quiz - DATABASE MANAGEMENT AND DESIGN

String literal values are always represented Literal values are not allowed As is, with no special punctuation Surrounded by single quotation marks Surrounded by double quotation marks

Surrounded by single quotation marks

Conditions connected by OR will be true only when just one condition is true only when both conditions are true when either condition is true when both conditions are false

when either condition is true

The maximum number of clauses in an SQL Select statement is: 2 4 8 6

6

To sort the result in alphabetical order you use the key word Desc Alphabetical Asc Numeric

Asc

Which of the following is not a comparison operator used in the Where clause? <> <= > !=

!=

The minimum number of clauses in an SQL Select statement is: 6 2 8 4

2

The meaning of Month in Month(SaleDate) is: Month is not a legitimate term in SQL A function that returns the name of the month in the date A function that returns an abbreviation for the month in the date A function that returns the number of the month in the date

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

Numeric literal values are always represented Surrounded by double quotation marks Literal values are not allowed Surrounded by single quotation marks As is, with no special punctuation

As is, with no special punctuation

To sort the result in reverse alphabetical order you use the key word No key word is needed Reverse You cannot sort in reverse alphabetical order Desc

Desc

To eliminate duplicate values, put into the Select clause the key word Only Distinct Redundant Unique

Distinct

The clause that identifies the tables the query should access is: Order by Where Select From

From

The order in which SQL Select clauses are executed is: Order by, Select, From, Where From, Where, Select, Order by Select, From, Where, Order by Where, From, Select, Order by

From, Where, Select, Order by

* in an SQL Select statement means: Exactly 1 character List all columns 0 or more characters Many

List all columns

The order of precedence for AND, OR, and NOT is: NOT, OR, AND AND, NOT, OR NOT, AND, OR AND, OR, NOT

NOT, AND, OR

The clause that says how the rows in the query result should be sorted is: Select From Where Order by

Order by

The clause that says which columns to list in the query result is: Select Where Order by From

Select

A query that accesses a single table is called: Beginning Simple Basic Fundamental

Simple

The first column listed in the Order by clause is: The last column in the Select clause The primary sort key The secondary sort key The first column in the Select clause

The primary sort key

The clause the gives the condition for selecting rows is: Select Order by Where From

Where

Conditions connected by AND will be true when either condition is true only when both conditions are true when one condition is false when neither condition is true

only when both conditions are true