Oracle 2nd quiz

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

ALL

A(n) ____ flashback query allows you to pull data from a database at a specific point in time.

AS OF

____ validates an expression as being between two values, and is inclusive.

BETWEEN

The most commonly used indexes for an Oracle database are ____ indexes.

BTree

The ____ clause is a special SQL clause used to retrieve the first value of each group in a set of duplications.

DISTINCT

The ____ table is used to request data from an Oracle database, where that data is not in user application tables.

DUAL

If you obtain a description of the DUAL table using the DESC command in SQL*Plus Worksheet, you will see that the only column present is called ____.

DUMMY

Queries can be summarized or aggregated into fewer rows using the GROUP BY and ____ clauses.

HAVING

____ set membership evaluates an expression as being within a set of elements.

IN

____ pattern matches between strings and using pattern expressions.

LIKE

A ____ valued column has never been set to anything (not yet accessed), or has been deliberately set to this value.

NULL

The ____({value}, {replace}) function replaces NULL values in expressions, avoiding SQL errors.

NVL

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

ROWNUM

The following query returns a single number as a total (or sum) of all blocks, used by all datafiles in the database: ____.

SELECT SUM(BLOCKS FROM DBA_DATA_FILES;

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

Sequences

____ is used to represent one and only one character.

_

A(n) ____ can act to apply a distinct name to multiple columns with the same name.

alias

Comparison of a NULL value to any other value will always evaluate to ____.

false

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

inner

____ is used as a pattern-matching character representing zero or more characters in a subset of a string.

%