Ch 2 Quiz - Database Management and Design

Ace your homework & exams now with Quizwiz!

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


Related study sets

Chapter 69: Management of Patients With Neurologic Infections, Autoimmune Disorders, and Neuropathies

View Set

Test #5 Davis's questions....................................

View Set

History of Student Affairs - Study Guide 1 (COMPS)

View Set

fin 240 kaplowitz worksheet 8.1: trademarks and related property and patents

View Set

Technology in action Final study set

View Set

Music in the Rock Era Chapter test questions

View Set