The _____ command replaces the ***** in the syntax of the update command, shown above.

The _____ operator could be used in place of minus if the dbms does not support it.

The ________ keyword is required to use relational operators in a case statement.

The action of including only some columns for output while retrieving data is known as ____.

The ansi standard defines _____ type(s) of outer join(s)

The ____ clause lets you group data on a particular column.

What keyword is used to check for a range of values?

What clause is used to sort data and group it?

True or False? This query is valid the way it is structured. SELECT * FROM Prospects WHERE assignment_type <> 'Team' AND criteria is not null

The HAVING clause can be used for what purpose?

What is the term for a set of data elements (values) organized using rows and columns?