Exam 6: The Basics of Querying a Database

In an ascending sort,NULL values will be returned ____________________.

____________________ SQL functions operate on one row at a time.

NULL can be tested for using the IS [ NOT ] ____________________ conditional operator.

Oracle SQL allows full expression-based use of both provided (built-in)and user-definable functions.

NULL values are not included in the most commonly used indexes for an Oracle database.

The ____ SQL group function returns the average of a group of values.

Sorting allows resorting of query results using the ____ clause.

____________________ SQL functions convert values such as numbers to strings.

The ____ SQL group function returns the highest value from a group of values.