Oracle
1Z0-074 · Question #48
1Z0-074 Question #48: Real Exam Question with Answer & Explanation
The correct answer is B. A sequence's unallocated cached value are lost if the instance shuts down E. A sequence can only be dropped by a DBA F. A sequence number that was allocated can be rolled back if a transaction fails. Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6015.htm
Question
Which three statements are true about sequences in a single instance Oracle database? (Choose three.)
Options
- AA sequence can issue duplicate values
- BA sequence's unallocated cached value are lost if the instance shuts down
- CSequences can always have gaps
- 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
Explanation
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6015.htm
Community Discussion
No community discussion yet for this question.