Explain the difference between a data block, an extent and a
segment.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gaya
The oracle server manages the storage space in the datafiles
in units called oracle blocks or data blocks.
A segment is the space allocated for a specific logical
storage structure within a tablespace.
Space is allocated to a segment by extents.One or more
extents make up a segments.
Is This Answer Correct ? | 6 Yes | 7 No |
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
Explain how you would restore a database using RMAN to Point in Time?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
What does coalescing a tablespace do?
what are the performance views in an oracle rac environment?
Datapump backup steps?
If we issue alter database begin backup. What happens to database?
What is a correlated sub-query? : sql server DBA
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 600?
How can you control the amount of free space in your index pages? : sql server DBA
Give two examples of how you might determine the structure of the table DEPT.