Multiple choice technology databases

What is true about Sequences?

  1. Once created, a sequence belongs to a specific schema

  2. Once created, a sequence is linked to a specific table

  3. Once created, a sequence is automatically available to all users

  4. Only the DBA can control which squence is used by certain a table

  5. Once created, a sequence is automatically in all INSERT and UPDATE statements
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Once created, a sequence is an independent database object that generates unique numeric values. It's not tied to any specific table or schema - it's a schema object but available to all users with privileges. Sequences must be explicitly referenced in statements - they're not automatically used.

Keep practicing — related questions