why do we give pctfree and pctused in create table statement?

Question Posted / kittu_chintu2005

why do we give pctfree and pctused in create table statement?..

Answer / arul

pctfree and pctused only used for DMT tablespace for extent management allocations

Is This Answer Correct ?

2 Yes

2 No

More DB Administration Interview Questions

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

Give the reasoning behind using an index.

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

How can you control the amount of free space in your index pages? : sql server DBA

How can you enable a trace for a session?

wat is global index and local indes

how will you see when the database was started using sql prompt?

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

I lost one datafile i dont have backup how can you recover that???

What are statistics, under what circumstances they go out of date, how do you update them?

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

For more DB Administration Interview Questions Click Here