What is an Extent ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
An Extent is a specific number of contiguous data blocks,
obtained in a single allocation, used to store a specific
type of information
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mahima
it is basic unit of storage space for table and index. it
allocate s0pace for table and index row data.its having 8
64k datapages.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
An extent is a contiguous area of storage reserved for a file in a file system, represented as a range. A file can consist of zero or more extents; one file fragment requires one extent.
Is This Answer Correct ? | 0 Yes | 0 No |
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What are the various constraints used in oracle?
How to install oracle database 10g xe?
How to define a specific record type?
what are the advantages of running a database in archive log mode?
Explain the use of owner option in exp command.
What is forall Statement ?
Describe Referential Integrity ?
Explain temporal data types in oracle
if you ctreate table identity
What are the different editions of oracle?