Exam 1z0-082 topic 1 question 38 discussion

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??

BEF https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/DBA_SEGMENTS.html#GUID-7BF4F8C7-1917-4532-B048-C044E17A1754

Which three are types of segments in an Oracle Database? (Choose three.) : • A. sequences • B. clusters • C. views • D. stored procedures • E. undo • F. tables

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

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

Undo are called Rollback segments, so correct is ΒEF

A, B, and E the correct answers.

ABEF - All tested on 19c

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

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

A is also correct Taken from the Oracle Administrators Workshop Study Guide: The different types of segments include: - Table and cluster - Index - Undo - Temporary