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 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


Correct Option: C,D

Find more quizzes: