Multiple choice technology databases

Once a sequence is created

  1. It is automatically used in all INSERT and UPDATE

  2. It is linked to a specific table.

  3. It belongs to a specific schema.

  4. It is automatically available to all users.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Sequences are independent database objects that belong to a specific schema (like tables, views, and other schema objects). They are not automatically used in any statements, not linked to specific tables, and not available to all users unless granted. A sequence must be explicitly referenced (e.g., NEXTVAL) and can be used across multiple tables.

Keep practicing — related questions