Question

Which statement describes a feature of Oracle sequences? Oracle sequences generate a character string that can be assigned to tables. Oracle sequences are tied to columns and tables. An Oracle sequence uses the identity column property to automatically number rows. Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.

Answer 1

Answer:

An Oracle sequence uses the identity column property to automatically number rows.

Explanation:

An Oracle sequence is a tool that can be used to generate a number sequence. Oracle has the capacity to help you create an auto-number field by using one of its tools called sequence.

A sequence is an object in Oracle that is used to generate a number sequence for input to a table. This is required when you need to generate primary key values by the use of identity columns.

So, Oracle sequence can automatically number rows by the use of identity columns.