Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Explain the difference between a data block, an extent and a
segment.

Question Posted / guest

Answers were Sorted based on User's Feedback



Explain the difference between a data block, an extent and a segment...

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

Explain the difference between a data block, an extent and a segment...

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

Post New Answer

More DB Administration Interview Questions

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

What is replication? : sql server DBA

0 Answers  

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

What the different types of replication and why are they used? : sql server DBA

0 Answers  

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

Name a tablespace automatically created when you create a database.

5 Answers  

What is the default fill factor value? : sql server DBA

0 Answers  

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

For more DB Administration Interview Questions Click Here
Categories