Which two statements are true about sequences created in a single instance database? (Choose two.)
A.
When the MAXVALUE limit for the sequence is reached, you can increase the MAXVALUE limit by using the
ALTER SEQUENCE statement.
B.
DELETE <sequencename> would remove a sequence from the database.
C.
The numbers generated by a sequence can be used only for one table.
D.
CURRVAL is used to refer to the last sequence number that has been generated.
E.
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.
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_2012.htm#SQLRF00817
https://docs.oracle.com/cd/A84870_01/doc/server.816/a76989/ch26.htm