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 types of connection load-balancing?
internal architecture
how can you communicate with operating system files from oracle?
what is the diffrence between core dba and apps dba?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what are the differences of where and if in SAS?
What is dbcc? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you create a user-defined lock?
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?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Why does Oracle not permit the use of PCTUSED with indexes?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).