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. https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6015.htm

Creating Other Schema Objects

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

(29 responses)

A
10% (3)
B
83% (24)
C
3% (1)
D
3% (1)

Explanation

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

Topics

#sequences#sequence cache#sequence gaps#DDL

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice