Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a data block, an extent and a
segment.
- 2 Answers
- 10622 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
who owns the operating system files created by the utl_file package?
What is a correlated sub-query? : sql server DBA
What are the recovery models for a database? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What authentication modes does sql server support? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is logical system in sap basis
Where would you look for errors from the database engine?
What are the different types of indexes available in sql server? : sql server DBA
what are the benefits of flashback feature?
what is asm?
What are the different ways you can create databases in sql server? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
