1) What event would cause the CACHE clause in CREATE SEQUENCE to make an out of sequence next number?
None - it will always issue the next sequential value when asked. But the transaction asking doesn't have to use the provided value as the PK for the table or, and even if it does, if the transaction fails and rolls-back the sequence value it received is discarded/lost.
