The Oracle equivalent to an MS Access AutoNumber is a(n) _____.
A) auto-number
B) sequence
C) TO_NUMBER function
D) trigger

Question

Quizplus · Accepted Answer

In Oracle, the sequence is the equivalent of an MS Access AutoNumber. A sequence is a database object that generates a sequence of unique values on demand and can be used as the source of an auto-increment column. A trigger is not the direct equivalent, as it is a database object that is triggered by a specific event and executes a set of actions in response. TO_NUMBER is a built-in SQL function that is used to convert a string or a date expression to a number. An auto-number is not a valid object type in Oracle.

The Oracle Equivalent to an MS Access AutoNumber Is A(n)