Oracle
1Z0-082 · Question #154
Which three statements are true about sequences in a single instance Oracle database?
The correct answer is B. A sequence can Issue duplicate values. C. A sequence's unallocated cached values are lost if the instance shuts down. D. Two or more tables cannot have keys generated from the same sequence. See the full explanation below for the reasoning.
Manage Schema Objects
Question
Which three statements are true about sequences in a single instance Oracle database?
Options
- ASequences can always have gaps.
- BA sequence can Issue duplicate values.
- CA sequence's unallocated cached values are lost if the instance shuts down.
- DTwo or more tables cannot have keys generated from the same sequence.
- EA sequence can only be dropped by a DBA.
- FA sequence number that was allocated can be rolled back if a transaction fails.
How the community answered
(40 responses)- A3% (1)
- B83% (33)
- E10% (4)
- F5% (2)
Topics
#sequences#cache#gaps#duplicate values
Community Discussion
No community discussion yet for this question.