|
INTERVIEW QUESTIONS
ORACLE
DATABASE ADMINISTRATION
DETAILS
Question: What is a data segment
Answer: A segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace. For example, for each table, Oracle allocates one or more extents to form that table's data segment, and for each index, Oracle allocates one or more extents to form its index segment. Oracle databases use four types of segments, which are described in the following sections: A single data segment in an Oracle database holds all of the data for one of the following: A table that is not partitioned or clustered A partition of a partitioned table A cluster of tables
|
|
|
Category |
Database Administration Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 8457 users |
Added on |
8/6/2011 |
Views |
68899 |
Rate it! |
|
|
Question:
What is a data segment
Answer:
A segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace. For example, for each table, Oracle allocates one or more extents to form that table's data segment, and for each index, Oracle allocates one or more extents to form its index segment. Oracle databases use four types of segments, which are described in the following sections: A single data segment in an Oracle database holds all of the data for one of the following: A table that is not partitioned or clustered A partition of a partitioned table A cluster of tables Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Database Administration Interview Questions & Answers - Exam Mode /
Learning Mode
|