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
