MIS 380
The SQL statement used to enter new rows into a table is: Add Insert Append Update
Insert
The From clause can contain a second name for a table. This name is called an alias. True False
True
The first column listed in the Order by clause is the primary sort key. True False
True
The clause the gives the condition for selecting rows is the _____ clause.
where
To eliminate duplicate values in the answer use this word in the Select clause: _____.
distinct
The maximum number of clauses in an SQL Select statement is:
6
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 _____. (enter a digital number)
2
Numeric literal values are always represented Literal values are not allowed Surrounded by single quotation marks Surrounded by double quotation marks As is, with no special punctuation
As is, with no special punctuation
The SQL statement used to take rows out of a table is: Retract Subtract Remove Delete
Delete
To eliminate duplicate values you put into the Select clause the key word Unique Redundant Distinct Only
Distinct
!= means "is not equal to" in the Where clause. True False
False
Month in Month(SaleDate) is a function that returns the name of the month in the date. True False
False
Numeric literal values are always represented surrounded by single quotes..
False
To sort the result in alphabetical order you use the key word Alphabetic. True False
False
The order in which the four SQL query clauses are executed is _____ _____ _____ _____. (separate your answers by commas.)
From, Where, Select, Order by
A column whose value is always unique in every row in a table is called a(n) _____.
Key
* in an SQL Select statement means:
List all columns
The order of precedence for AND, OR, and NOT is:
NOT, AND, OR
To override precedence of AND, OR, and NOT, use: Parentheses Square brackets Curly braces Precedence cannot be overridden
Parentheses
A query that accesses a single table is called a(n) ________ query.
Simple
The first column listed in the Order by clause is: The secondary sort key The primary sort key The last column in the Select clause The first column in the Select clause
The primary sort key
The maximum number of tables that can be joined in an SQL Select statement is: There is no maximum 6 4 2
There is no maximum
The SQL statement used to change data in an existing row is: Alter Revise Change Update
Update
The process of linking records in different tables to execute a query is called a(n) _____.
join