|
Question |
Rating |
View Answer |
|
What is meant by recursive hints |
|
View Answer |
|
What are the factors causing the reparsing of SQL statements in SGA |
|
View Answer |
|
What is an overlay? |
|
View Answer |
|
How will you estimate the space required by a non-clustered tables? |
|
View Answer |
|
What are the different kind of export backups? |
|
View Answer |
|
What is use of LOG (Ver 7) option in EXP command ? |
|
View Answer |
|
Why would an overlay be used? |
|
View Answer |
|
How does memory compaction work? |
|
View Answer |
|
What is the method of relocation? |
|
View Answer |
|
Which parameter in Storage clause will reduce no. of rows per block? |
|
View Answer |
|
What is dictionary cache ? |
|
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 to expand into another extend. |
|
View Answer |
|
What is the functionality of SYSTEM table space |
|
View Answer |
|
How will you force database to use particular rollback segment ? |
|
View Answer |
|
What is SGA? How it is different from Ver 6.0 and Ver 7.0? |
|
View Answer |
|
Why are page sizes powers of two? Why is this necessary? |
|
View Answer |
|
List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ? |
|
View Answer |
|
What is hot backup and how it can be taken? |
|
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 Shared SQL pool? |
|
View Answer |