Sequences

After a value is generated, it is stored in the ____________________ pseudocolumn so it can be referenced again by a user.

CURRVAL

The CURRVAL pseudocolumn is used to generate the next value in a sequence.

False

A negative number can be assigned to the ____ clause to generate sequential numbers in decreasing order.

INCREMENT BY

A(n) ____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.

Sequence

A(n) ____________________ can be used for internal control purposes by generating a series of numbers.

Sequence

Pre-generated sequence numbers that have not been used when the database is shut down will no longer be available when the database is restarted.

TRUE

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in ascending order.

True

When a sequence is created for internal control purposes, the values should not be cached otherwise gaps may appear in the sequence.

True

A(n) ____________________ synonym can be referenced by other database users.

public

A(n) ____________________ can be used to generate values for a column designated as the primary key for a table.

sequence