Exam 6: The Basics of Querying a Database

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

A(n)____ join combines rows from both tables using matching column names and column values.

Use of upper- and lowercase is only a factor in queries for strings or expressions enclosed in Oracle database quotation marks.

Top-N queries are executed by filtering against the ____ pseudocolumn.

To find the currently logged in user name and his (or her)user identifier you can use the following command: SELECT USER,UID FROM ____________________;

____________________ represents nothing,not a space,not a zero (0),or even an unknown value;simply nothing.

The ____ clause allows a hierarchical query to begin displaying within a hierarchical structure,with a specified column and value.

The AS clause can be used in the ORDER BY clause.

EXISTS is sometimes faster than IN.

ANY,SOME,and ____ check set membership and allow subqueries that return multiple rows.

AS is often used to check membership of one element in a list of elements.

____ are automated counters,counting from a specific value,up to a specified maximum (or an enormous value with no maximum specified).

Most Oracle database built-in functions will return a NULL value when passed a NULL value.

____________________ is a pseudocolumn generated for each row,in sequence,as each row is returned from a query.

____ queries use the ORDER BY clause to return rows in a specified order.

____________________ are executed within other queries.

A(n)____________________ query concatenates columns and rows of two queries.

Selecting values greater than ROWNUM,as opposed to less than,or less than or equal to ROWNUM,will return no rows whatsoever.

Group (____________________)SQL functions apply specific functionality to grouping and summary queries.

New tables and views can be created from the results of a query.