Which two statements are true about sequences created in a single instance database?
(Choose two.)
A.
When a database instance shuts down abnormally, the sequence numbers that have
been cached but not used would be available once again when the database instance is
restarted
B.
When the MAXVALUE limit for a sequence isreached, you can increase the MAXVALUE
limit by using the ALTER SEQUENCE statement
C.
CURRVAL is used to refer to the last sequence number that has been generated
D.
The numbers generated by a sequence can be used only for one table
E.
DELETE <sequencename> would remove a sequence from the database
https://docs.oracle.com/cd/A84870_01/doc/server.816/a76989/ch26.htm
Use the ALTER SEQUENCE statement to change the increment, minimum and maximum values, cached numbers, and behavior of an existing sequence. This statement affects only future sequence numbers.
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_2011.htm#SQLRF00817