What is true about Sequences?
-
Once created a sequence belongs to a specific schema.
-
Once created, a sequence is linked to a specified table.
-
Once created a sequence is automatically available to all users.
-
Only the DBA can control which sequence is used by a certain table.
-
Once created a sequence is automatically used in all INSERT and UPDATE statements.
Reveal answer
Fill a bubble to check yourself
A,C
Correct answer
Explanation
Sequences in Oracle are independent schema objects (not tied to specific tables) that generate unique numeric values. Once created in a schema with appropriate permissions, sequences can be referenced and used by multiple users, tables, and applications through explicit calls (sequence.NEXTVAL, sequence.CURRVAL). They are not automatically applied to any operations.