Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a data block, an extent and a
segment.
- 2 Answers
- 10700 Views
- I also Faced
- E-Mail Answers
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 is fill factor? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you schedule a job in database?
which background process invoke at the time of upgradation tell me???
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is a correlated sub-query? : sql server DBA
Why would you use sql agent? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the recovery models for a database? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what is a user-defined lock?
Query processing is slow(eg select query)how will u solve that
