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

Which two statements are true about sequences created in a single instance database? (Choose two.)

Which two statements are true about sequences created in a single instance database? (Choose two.)

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

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

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

D.
When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement.

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *