1.User Segments
-Table, table partition, or table cluster
-LOB or LOB partition
-Index or index partition
2.Temporary Segments
3.Undo Segments
Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html#GUID-7DA83E64-9FF1-45A7-A9AC-D4997DDE0866
A B E F should be correct??
Cluster segments are less common in 19C version compared to older version. Also, Rollback segments were used on oracle version less than 10g, this make undo segment being valid answer for version upper than 9i. Thus, my answers are ABE.
Again a question with four possible answers and not three.
select the distinct segment_type from dba_segments to get a list of all the segment types.
A is correct.
B is correct.
C is wrong.
D is wrong.
E is correct.
F is correct.
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_SEGMENTS.html#GUID-7BF4F8C7-1917-4532-B048-C044E17A1754
Segment types
There are 11 types of segments in Oracle 10g:
table
table partition
index
index partition
cluster
rollback
deferred rollback
temporary
cache
lobsegment
lobindex
These types can be grouped into four segment classes:
data segments: table and cluster
index
rollback
temporary data
From the Oracle 19c documentation:
User Segments
A single data segment in a database stores the data for one user object.
There are different types of segments. Examples of user segments include:
Table, table partition, or table cluster
LOB or LOB partition
Index or index partition
Each nonpartitioned object and object partition is stored in its own segment. For example, if an index has five partitions, then five segments contain the index data.
https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html#GUID-EFB292CB-87EA-42AA-808C-BD85E540BACC
A is also correct
Taken from the Oracle Administrators Workshop Study Guide:
The different types of segments include:
- Table and cluster
- Index
- Undo
- Temporary
From Oracle 9i, undo is managed by undo tablespace, and not with rollback segment anymore. Hence we have rollback segment, but not undo segment.
upvoted 4 times
...
...
This section is not available anymore. Please use the main Exam Page.1z0-082 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ogdru
Highly Voted 4 years, 4 months agoGuhborges
3 years, 9 months agoNowOrNever
Highly Voted 4 years, 10 months agoEkos
4 years, 7 months agoronie_23
Most Recent 1 year, 3 months agoguimaleo
1 year, 5 months agolahiruwic
1 year, 6 months agozouve
1 year, 11 months agoauwia
2 years agoauwia
2 years agoauwia
2 years agoFelipeC
2 years, 5 months agoFranky_T
3 years, 3 months agoAramazd
3 years, 3 months agoryuah
3 years, 6 months agobrolem
3 years, 11 months agoBorislone
4 years agoadoptc94
4 years, 10 months agoPhat
4 years, 4 months ago