Oracle
1Z0-071 · Question #94
Which two statements are true about sequences crated in a single instance Oracle database?
The correct answer is C. CURRVAL is used to refer to the most recent sequence number that has been generated for a D. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER. See the full explanation below for the reasoning.
Question
Which two statements are true about sequences crated in a single instance Oracle database?
Options
- AThe numbers generated by an explicitly defined sequence can only be used to insert data in one
- BDELETE <sequencename> would remove a sequence from the database.
- CCURRVAL is used to refer to the most recent sequence number that has been generated for a
- DWhen the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER
- EWhen the database instance shuts down abnormally, sequence numbers that have been cached
How the community answered
(21 responses)- A10% (2)
- B5% (1)
- C81% (17)
- E5% (1)
Community Discussion
No community discussion yet for this question.