Explain the difference between a data block, an extent and a
segment.
Answer Posted / wafa
data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is the diffrence between core dba and apps dba?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What happens on checkpoint? : sql server DBA
what do you understand by fine-grained auditing?
how can you initialize log miner?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Query processing is slow(eg select query)how will u solve that
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how to restore files with rman?
how does an oracle clusterware manage crs resources?