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?

ASequences can always have gaps.

BA sequence can Issue duplicate values.

CA sequence's unallocated cached values are lost if the instance shuts down.

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.

Show Suggested 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

2 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

1 months ago

Yeah, sequences can have gaps, lose unallocated values, and rollback allocated numbers.

upvoted 0 times

...

Alisha

1 months ago

I think you're right, A, C, and F are correct.

upvoted 0 times

...

Gail

2 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

1 months ago

Yes, F is true, a sequence number that was allocated can be rolled back if a transaction fails.

upvoted 0 times

...

Jesusita

2 months ago

I'm not sure about F, can a sequence number that was allocated be rolled back?

upvoted 0 times

...

Annamaria

2 months ago

I agree, C is also true, unallocated cached values are lost if the instance shuts down.

upvoted 0 times

...

Doyle

2 months ago

I think A is correct, sequences can have gaps.

upvoted 0 times

...

Cecil

3 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

3 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

1 months ago

I've also seen duplicate values from sequences and multiple tables sharing a sequence.

upvoted 0 times

...

Refugia

1 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

1 months ago

Yes, sequences can issue duplicate values and multiple tables can share a sequence.

upvoted 0 times

...

Carole

2 months ago

I agree, sequences can have gaps and unallocated cached values are lost on shutdown.

upvoted 0 times

...

Honey

3 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

2 months ago

Yes, unallocated cached values are lost if the instance shuts down.

upvoted 0 times

...

Reta

2 months ago

I agree, sequences can have gaps.

upvoted 0 times

...

Audria

3 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

3 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

3 months ago

I think statement A is true because sequences can have gaps.

upvoted 0 times

...