How does Space allocation table place within a block ?

Question Posted / guest

1 Answers
4029 Views
I also Faced
E-Mail Answers

How does Space allocation table place within a block ?..

Answer / orawhiz

Each block contains entries as follows
Fixied block header
Variable block header
Row Header,row date (multiple rows may exists)
PCTEREE (% of free space for row updation in future)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Architecture Interview Questions

What is the function of ARCH?

3 Answers

How will you create multiple rollback segments in a database ?

1 Answers

How to implement the multiple control files for an existing database ?

2 Answers

How will you estimate the space required by a non-clustered tables?

2 Answers

Teradata: How can we know the indexed column in a table?

0 Answers CTS, HSBC,

What is PGA?

5 Answers

What is a Parallel Server option in ORACLE?

1 Answers

what is the role of archiever

4 Answers Baidu, Satyam, TCS,

How the log writer writes the data into database

4 Answers Baidu, Satyam,

What is dictionary cache ?

2 Answers

What are the uses of Oracle Rollback Segment?

0 Answers

What is meant by free extent ?

2 Answers

For more Oracle Architecture Interview Questions Click Here