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

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

Question Posted / guest

2 Answers
10605 Views
I also Faced
E-Mail Answers

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

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers

What is the default port no on which sql server listens? : sql server DBA

0 Answers

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?

0 Answers HSBC,

Why would you use sql agent? : sql server DBA

0 Answers

What are the recovery models for a database? : sql server DBA

0 Answers

what is difference between user managed backup and rman backup?

1 Answers CTS,

When a user process fails, what background process cleans up after it?