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