Which two statements are true about sequences crated in a single instance Oracle database?
A. The numbers generated by an explicitly defined sequence can only be used to insert data in one table.
B. DELETE <sequencename> would remove a sequence from the database.
C. CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.
D. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.
E. When the database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted
|
Download Printable PDF. VALID exam to help you PASS. |
 |