Multiple choice technology programming languages

Which two statements are true about sequences created in a single instance database?

  1. The numbers generated by a sequence can be used only for one table

  2. DELETE <sequencename> would remove a sequence from the database

  3. CURRVAL is used to refer to the last sequence number that has been generated

  4. When the MAXVALUE limit for a sequence for reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

CURRVAL returns the most recently generated sequence number for the current session. When a sequence hits its MAXVALUE, its maximum limit can be increased using the ALTER SEQUENCE statement. DELETE is used for rows, not dropping database objects like sequences.

Keep practicing — related questions