Explain the difference between a data block, an extent and a
segment.
- 2 Answers
- 10287 Views
- I also Faced
- E-Mail Answers
Answer Posted / gaya
The oracle server manages the storage space in the datafiles
in units called oracle blocks or data blocks.
A segment is the space allocated for a specific logical
storage structure within a tablespace.
Space is allocated to a segment by extents.One or more
extents make up a segments.
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
What is the default port no on which sql server listens? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the different types of indexes available in sql server? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can you initialize log miner?
Where do you find the default index fill factor and how to change it? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is transparent data encryption? : sql server DBA
how can you connect from 10g user to 11g user??
What are the commands you'd issue to show the explain plan for "select * from dual"?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
