Oracle Exam 1Z0-082 Topic 3 Question 89 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 89
Topic #: 3

[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 Mozell at Apr 10, 2024, 09:12 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Brittney

7 hours ago

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

upvoted 0 times

...

Pura

22 days ago

Haha, I bet the exam writer is just trying to trip us up with this one. They probably want us to overthink it. I'm going to go with my gut on this - A, C, and F seem the most reliable to me.

upvoted 0 times

...

Hmm, I'm a bit uncertain about B. I thought sequences were designed to avoid duplicate values, but maybe there's some edge case where it could happen. And F, I'm not sure if that's true or not. Guess I'll have to review my sequence knowledge.

upvoted 0 times

...

Sage

25 days ago

I think D is true - two or more tables can't use the same sequence to generate keys. That would cause all sorts of problems. And E, I believe a sequence can only be dropped by a DBA, not a regular user.

upvoted 0 times

...

Arminda

26 days ago

I agree with Denae on those three options. But I'm not sure about the others. B seems false - a sequence should never issue duplicate values. And D and E, I'm not confident about those.

upvoted 0 times

...

Denae

28 days ago

Hmm, I think options A, C, and F are true. Sequences can have gaps if you don't use them consecutively, and if the instance shuts down, any unallocated cached values are lost. And if a transaction fails, the sequence number that was allocated can be rolled back.

upvoted 0 times

...

Louis

30 days ago

I'm not too sure about this question. It seems to cover a lot of different aspects of sequences in Oracle, and I'm not familiar with all the nuances. I'll have to think this through carefully.

upvoted 0 times

...

Oracle Exam 1Z0-082 Topic 3 Question 89 Discussion

Contribute your Thoughts:

Brittney

Pura

Bulah

Sage

Arminda

Denae

Louis