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