Oracle Exam 1Z0-082 Topic 2 Question 116 Discussion

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

Question #: 116
Topic #: 2

[All 1Z0-082 Questions]

Which three statements are true concerning logical and physical database structures? (Choose three.)

AAll tablespaces may have one or more data files

BThe extents of a segment must always reside in the same datafile

CA smallfile tablespace might be bigger than a bigfile tablespace

DA segment can span multiple data files in some tablespaces

EA segment's blocks can be of different sizes

FA segment might have only one extent

GSegments can span multiple tablespaces

Show Suggested Answer

Suggested Answer: B, C, F

by Hollis at Apr 30, 2025, 04:39 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Julio

12 days ago

Interesting, Erin. Can you explain why you think so?

upvoted 0 times

...

Silva

13 days ago

This exam is really testing our knowledge of the nitty-gritty details of database structures. I'm going to go with B, D, and F. A segment might have only one extent, that's an interesting one!

upvoted 0 times

...

Avery

14 days ago

Haha, E is a trick question. A segment's blocks can't be of different sizes, that would be chaos! I'm going with B, D, and G.

upvoted 0 times

Alita

3 days ago

I think B is correct because the extents of a segment must always reside in the same datafile.

upvoted 0 times

...

Erin

15 days ago

I believe B, E, and F are the correct statements.

upvoted 0 times

...

Lilli

1 months ago

I agree with you, Julio. Segments can definitely span multiple tablespaces.

upvoted 0 times

...

Kenneth

1 months ago

I'm not sure about C - a smallfile tablespace being bigger than a bigfile tablespace. That doesn't sound right to me. But I agree with B, D, and G.

upvoted 0 times

Artie

11 days ago

User1: I think C is incorrect, a smallfile tablespace can't be bigger than a bigfile tablespace.

upvoted 0 times

...

Julio

2 months ago

I think A, D, and G are true.

upvoted 0 times

...

I think B, D, and G are the correct answers. The extents of a segment must always reside in the same datafile, a segment can span multiple data files in some tablespaces, and segments can span multiple tablespaces.

upvoted 0 times

In

4 days ago

That's right, a segment can indeed span multiple data files in some tablespaces.

upvoted 0 times

...

Jacklyn

7 days ago

Yes, the extents of a segment must always reside in the same datafile.

upvoted 0 times

...

Penney

22 days ago

I agree, B, D, and G are the correct answers.

upvoted 0 times

...

Oracle Exam 1Z0-082 Topic 2 Question 116 Discussion

Contribute your Thoughts:

Julio

Silva

Avery

Alita

Erin

Lilli

Kenneth

Artie

Julio

Barabara

In

Jacklyn

Penney