Oracle
1Z0-047 · Question #45
Which two statements are true about sequences created in a single instance database? (Choose two.)
The correct answer is 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. See the full explanation below for the reasoning.
Question
Which two statements are true about sequences created in a single instance database? (Choose two.)
Options
- AThe numbers generated by a sequence can be used only for one table.
- BDELETE <sequencename> would remove a sequence from the database.
- CCURRVAL is used to refer to the last sequence number that has been generated.
- DWhen the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using
- EWhen a database instance shuts down abnormally, the sequence numbers that have been cached but
How the community answered
(16 responses)- B13% (2)
- C81% (13)
- E6% (1)
Community Discussion
No community discussion yet for this question.