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 purpose does the model database server? : sql server DBA
what is a user-defined lock?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what is the use of recording information about current session?
what do you understand by flashback feature of oracle?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
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 is a system database and what is a user database? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
How do you open a cluster administrator? : sql server DBA
What is replication? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
what is asm?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the difference between clustered and non-clustered index? : sql server DBA