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

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

Post New Answer

More DB Administration Interview Questions

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

Give the reasoning behind using an index.

2 Answers  




what is meant by gateway

1 Answers   IBM,

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

0 Answers  

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

internal architecture

0 Answers   CSC,

what is grd?

0 Answers   Oracle,

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

For more DB Administration Interview Questions Click Here
Categories