Oracle Exam 1Z0-082 Topic 3 Question 99 Discussion

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

Question #: 99
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 Venita at Aug 04, 2024, 12:21 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Elli

3 months ago

I think statement D is false because two or more tables can have keys generated from the same sequence.

upvoted 0 times

...

Caitlin

3 months ago

I believe statement E is true, only a DBA can drop a sequence.

upvoted 0 times

...

Carrol

3 months ago

I agree with statement C, unallocated cached values are lost if the instance shuts down.

upvoted 0 times

...

Merilyn

3 months ago

If a sequence could issue duplicate values, I'd call it a 'non-sequence'!

upvoted 0 times

...

Rex

3 months ago

Wait, are we talking about sequences in a database or a DNA lab? I'm so confused right now!

upvoted 0 times

...

Leonard

3 months ago

E is a bit tricky. I think a sequence can only be dropped by a DBA, but I'm not 100% sure on that one.

upvoted 0 times

Elvera

3 months ago

That's right. It's a security measure to prevent accidental deletion of sequences.

upvoted 0 times

...

Elvera

3 months ago

E is correct. A sequence can only be dropped by a DBA.

upvoted 0 times

...

Cassie

3 months ago

B is definitely false - a sequence can't issue duplicate values, that's the whole point of using a sequence!

upvoted 0 times

...

Rolland

3 months ago

I'm pretty sure D is also true. Two tables can't use the same sequence, right? That would be a mess!

upvoted 0 times

Earnestine

2 months ago

D) Two or more tables cannot have keys generated from the same sequence.

upvoted 0 times

...

Otis

2 months ago

C) A sequence's unallocated cached values are lost if the instance shuts down.

upvoted 0 times

...

Starr

3 months ago

E) A sequence can only be dropped by a DBA.

upvoted 0 times

...

Lili

3 months ago

A) Sequences can always have gaps.

upvoted 0 times

...

Lauran

3 months ago

D) Two or more tables cannot have keys generated from the same sequence.

upvoted 0 times

...

Izetta

3 months ago

C) A sequence's unallocated cached values are lost if the instance shuts down.

upvoted 0 times

...

Yasuko

3 months ago

B) A sequence can Issue duplicate values.

upvoted 0 times

...

Chan

3 months ago

A) Sequences can always have gaps.

upvoted 0 times

...

Maryln

4 months ago

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

upvoted 0 times

...

Rocco

4 months ago

I think statement F is false because once a sequence number is allocated, it cannot be rolled back.

upvoted 0 times

...

Janae

4 months ago

I'm not sure about statement F. Can a sequence number really be rolled back if a transaction fails?

upvoted 0 times

...

Nan

4 months ago

A, C, and F seem to be the correct answers. Sequences can have gaps, and unallocated cached values are lost on instance shutdown. A sequence number can be rolled back if a transaction fails.

upvoted 0 times

Devora

4 months ago

So, it seems like those are the correct statements about sequences in a single instance Oracle database.

upvoted 0 times

...

Leonor

4 months ago

Yes, that's right. A sequence number can be rolled back if a transaction fails.

upvoted 0 times

...

Agustin

4 months ago

I think A, C, and F are correct. Sequences can have gaps and lose unallocated cached values on shutdown.

upvoted 0 times

...

Lisandra

4 months ago

I agree with that. I also think statement C is true because cached values are lost when the instance shuts down.

upvoted 0 times

...

Rocco

4 months ago

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

upvoted 0 times

...