Which three are types of segments in an Oracle Database? (Choose three.)
Which three are types of segments in an Oracle Database? (Choose three.)
The types of segments in an Oracle Database include undo segments, index segments, and table segments. Undo segments store records to reverse changes made to the database, index segments are used to speed up the retrieval of rows, and table segments store the data of the user's tables. Clusters can also be a type of segment but given the choice of only three, undo, index, and table segments are the most commonly referenced in Oracle Database documentation as types of segments.
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??
I agree with A B E F, so this question is impossible, because they need only three
BEF https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/DBA_SEGMENTS.html#GUID-7BF4F8C7-1917-4532-B048-C044E17A1754
i agree
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
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.
Undo segment: Oracle Database 19c maintains information to reverse changes made to the database. This information consists of records of the actions of transactions, collectively known as undo. Undo is stored in undo segments in an undo tablespace.
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.
SELECT DISTINCT SEGMENT_TYPE FROM DBA_SEGMENTS; INDEX CLUSTER TABLE PARTITION LOBINDEX TABLE SUBPARTITION SYSTEM STATISTICS LOBSEGMENT INDEX PARTITION ROLLBACK TABLE LOB PARTITION NESTED TABLE TYPE2 UNDO
Undo are called Rollback segments, so correct is ΒEF
A, B, and E the correct answers.
I'm sorry I was wrong, provided answer are corrects.
B, E, and F are correct.
ABEF - All tested on 19c
SQL> select distinct SEGMENT_TYPE from dba_segments; SEGMENT_TYPE ------------------ INDEX CLUSTER TABLE PARTITION LOBINDEX TABLE SUBPARTITION SYSTEM STATISTICS LOBSEGMENT INDEX PARTITION ROLLBACK TABLE LOB PARTITION NESTED TABLE TYPE2 UNDO
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
B,E,F is correct
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
AEF is correct