|
Question |
Rating |
View Answer |
|
What is dictionary cache ? |
|
View Answer |
|
What is Database Buffers ? |
|
View Answer |
|
What are the factors causing the reparsing of SQL statements in SGA? |
|
View Answer |
|
What is a data segment? |
|
View Answer |
|
What is mean by Program Global Area (PGA) ? |
|
View Answer |
|
What is a Shared SQL pool? |
|
View Answer |
|
What is SGA? How it is different from Ver 6.0 and Ver 7.0? |
|
View Answer |
|
List the factors that can affect the accuracy of the estima |
|
View Answer |
|
What are disadvantages of having raw devices |
|
View Answer |
|
When will be a segment released |
|
View Answer |
|
What is hit ratio |
|
View Answer |
|
What is a rollback segment entry |
|
View Answer |
|
What is use of rollback segments in Oracle database |
|
View Answer |
|
What is advantage of having disk shadowing / mirroring |
|
View Answer |
|
How redo logs can be achieved |
|
View Answer |
|
What is redo log file mirroring |
|
View Answer |
|
How to implement the multiple control files for an existing database |
|
View Answer |
|
What is a Control file |
|
View Answer |
|
It is possible to use raw devices as data files and what are the advantages over file system files |
|
View Answer |
|
How will you estimate the space required by a non-clustered tables |
|
View Answer |