Which of the following are segment types in a database? Each correct answer represents a complete solution. Choose all that apply.

Answer: A,B,D

Explanation: Answer options D, A, and B are correct. The four types of segments in a database are as follows : 1. Data segment 2. Index segment 3. Undo segment 4. Temporary segment. Each non-cluster, non-IOT table has a data segment. Indexes are stored in index segments. Undo segments are stored in an UNDO tablespace , and contains information needed for readconsistency and to roll back transactions. Temporary segments are stored in a temporary tablespace and are used when there is not enough room in memory to perform a SQL statement's sorting operation. C is incorrect. A schema is the entire collection of objects owned by a database user. A schema object can be a table, view, index, cluster, synonym, etc. Schema objects are at a much higher logical level than segments, although indexes are stored in index segments and tables are stored in data segments. Reference: Oracle Database 11g: Administration Workshop I Chapter 1: Exploring the Oracle Database Architecture Oracle Database Concepts 11g Release 1 (11.1) Part Number B28318-05 http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/intro.htm