Explain the difference between a data block, an extent and a
segment.
- 2 Answers
- 10229 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
how to restore files with rman?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is replication? : sql server DBA
what is a crs resource?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What is the default port no on which sql server listens? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Why would you use sql agent? : sql server DBA
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 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?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is ora 24313?what is the procedure to exclude that error?
What purpose does the model database server? : sql server DBA
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?
