Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Oracle Exam 1Z0-082 Topic 18 Question 112 Discussion

Actual exam question for Oracle's 1Z0-082 exam
Question #: 112
Topic #: 18
[All 1Z0-082 Questions]

Which three statements are true about sequences in a single instance Oracle database?

Show Suggested Answer Hide Answer
Suggested Answer: B, C, D

by Raina at Feb 09, 2025, 03:43 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Gail
3 months ago
Haha, I bet the sequence numbers are more unpredictable than a coin flip! Anyway, I think A, C, and F are the right answers.
upvoted 0 times
Rodolfo
2 months ago
Yeah, sequences can have gaps, lose unallocated values, and rollback allocated numbers.
upvoted 0 times
...
Alisha
3 months ago
I think you're right, A, C, and F are correct.
upvoted 0 times
...
...
Gail
3 months ago
This is a tricky one! I'm going with A, C, and F. Sequences are weird - they can have gaps, and allocated numbers can be rolled back.
upvoted 0 times
Noble
3 months ago
Yes, F is true, a sequence number that was allocated can be rolled back if a transaction fails.
upvoted 0 times
...
Jesusita
3 months ago
I'm not sure about F, can a sequence number that was allocated be rolled back?
upvoted 0 times
...
Annamaria
3 months ago
I agree, C is also true, unallocated cached values are lost if the instance shuts down.
upvoted 0 times
...
Doyle
3 months ago
I think A is correct, sequences can have gaps.
upvoted 0 times
...
...
Cecil
4 months ago
I'd say A, C, and E are the correct answers. Sequences can have gaps, and only a DBA can drop a sequence.
upvoted 0 times
...
Maile
4 months ago
Definitely A, C, and D are true. I've seen duplicate values from sequences before, and multiple tables can share a sequence.
upvoted 0 times
Winfred
2 months ago
I've also seen duplicate values from sequences and multiple tables sharing a sequence.
upvoted 0 times
...
Refugia
2 months ago
That's correct, a sequence can have gaps and multiple tables can have keys generated from the same sequence.
upvoted 0 times
...
Teri
3 months ago
Yes, sequences can issue duplicate values and multiple tables can share a sequence.
upvoted 0 times
...
Carole
3 months ago
I agree, sequences can have gaps and unallocated cached values are lost on shutdown.
upvoted 0 times
...
...
Honey
4 months ago
Hmm, I think A, C, and F are true. Sequences can have gaps, and unallocated cached values are lost on shutdown. Plus, allocated sequence numbers can be rolled back on transaction failure.
upvoted 0 times
Monroe
3 months ago
Yes, unallocated cached values are lost if the instance shuts down.
upvoted 0 times
...
Reta
3 months ago
I agree, sequences can have gaps.
upvoted 0 times
...
...
Audria
4 months ago
I disagree with statement D. I believe two or more tables can have keys generated from the same sequence.
upvoted 0 times
...
Marica
4 months ago
I agree with you, Ciara. I also think statement C is true because unallocated cached values are lost when the instance shuts down.
upvoted 0 times
...
Ciara
4 months ago
I think statement A is true because sequences can have gaps.
upvoted 0 times
...

Save Cancel