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

Question

Quizplus · Accepted Answer

Dropping an Oracle sequence in the database does not delete the values that have been assigned to the table attributes; it only removes the sequence object from the database. Therefore, dropping the sequence does not affect the existing table data. Option A is incorrect because a sequence is not tied to any column or table. It is an independent object in an Oracle database. Option B is incorrect because a sequence generates numeric values, not character strings. Option C is incorrect because Oracle sequences are distinct from the identity column property.

Which Statement Describes a Feature of Oracle Sequences