F-FALSE: When a sequence number is generated, the sequence is incremented, independent of the transaction committing or rolling back.
A-TRUE: If two users concurrently increment the same sequence, then the sequence numbers each user acquires may have gaps, because sequence numbers are being generated by the other user
I agree ACD
C-TRUE:when an instance abnormally shuts down (for example, when an
instance failure occurs or a SHUTDOWN ABORT statement is issued), sequence numbers that
have been cached but not used are lost.
The CACHE clause preallocates a set of sequence numbers and keeps them in memory so that
sequence numbers can be accessed faster
D-TRUE: If the sequence is cycle it can generate duplicate values.
B is wrong -> "Sequence numbers are generated independently of tables, so the same sequence can be used for one or for multiple tables"
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-SEQUENCE.html
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Oracle2020
3 months, 1 week agoOracle2020
3 months, 1 week agoOracle2020
3 months, 1 week agoauwia
1 year agoRaNik69
1 year, 1 month agopiontk
1 year, 4 months agopiontk
1 year, 4 months agoivanadj
1 year, 4 months ago