|
Related Questions |
View Answer |
|
How free extents are managed in Ver 6.0 and Ver 7.0 ?
|
View Answer
|
|
Which parameter in Storage clause will reduce no. of rows per block?
|
View Answer
|
|
What is the significance of having storage clause ?
|
View Answer
|
|
How does Space allocation table place within a block ?
|
View Answer
|
|
What is the role of PCTFREE parameter is Storage clause ?
|
View Answer
|
|
What is the OPTIMAL parameter?
|
View Answer
|
|
What is the functionality of SYSTEM table space ?
|
View Answer
|
|
How will you create multiple rollback segments in a database ?
|
View Answer
|
|
How the space utilization takes place within rollback segments ?
|
View Answer
|
|
Why query fails sometimes ?
|
View Answer
|
|
How will you monitor the space allocation ?
|
View Answer
|
|
How will you monitor rollback segment status ?
|
View Answer
|
|
List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment toexpand into another extend.
|
View Answer
|
|
How can we plan storage for very large tables ?
|
View Answer
|
|
How will you estimate the space required by a non-clustered tables?
|
View Answer
|
|
It is possible to use raw devices as data files and what is the advantages over file. system files ?
|
View Answer
|
|
What is a Control file ?
|
View Answer
|
|
How to implement the multiple control files for an existing database ?
|
View Answer
|
|
What is meant by Redo Log file mirroring ? How it can be achieved?
|
View Answer
|
|
What is advantage of having disk shadowing/ Mirroring ?
|
View Answer
|