Ch 2 Quiz - Database Management and Design

Numeric literal values are always represented

As is, with no special punctuation

The SQL statement used to take rows out of a table is:

Delete

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

NOT, AND, OR

To eliminate duplicate values in the answer use this word in the Select clause: _____.

distinct

A column whose value is always unique in every row in a table is called a(n) _____.

key

The clause the gives the condition for selecting rows is the _____ clause.

where

The SQL statement used to change data in an existing row is:

Update

The first column listed in the Order by clause is the primary sort key.

True