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
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
which background process invoke at the time of upgradation tell me???
what are the types of connection load-balancing?
Can you redefine a table online?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What the different components in replication and what is their use? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you get actual data change values from previous transactions in oracle?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the commands used in dcl? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What is a system database and what is a user database? : sql server DBA
what are the performance views in an oracle rac environment?