Which three statements are true about sequences in a single instance Oracle database? (Choose three.)

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

Administering a Multitenant Container Database

Question

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

How the community answered

(31 responses)

A
6% (2)
B
77% (24)
C
13% (4)
D
3% (1)

Explanation

Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6015.htm

Topics

#sequences#cached values#instance shutdown#sequence gaps

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice