|
Question |
Rating |
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 |
|
What is mean by Program Global Area (PGA) |
|
View Answer |
|
When will be a segment released ? |
|
View Answer |
|
What is a logical backup? |
|
View Answer |
|
What is the role of PCTFREE parameter is storage clause |
|
View Answer |
|
What are disadvantages of having raw devices |
|
View Answer |
|
How will you estimate the space required by a non-clustered tables |
|
View Answer |
|
What is use of Rollback Segments In Database ? |
|
View Answer |
|
What is a data segment? |
|
View Answer |
|
What is cold backup? What are the elements of it? |
|
View Answer |
|
What is the use of RECORD LENGTH option in EXP command ? |
|
View Answer |
|
What is the use of GRANT option in IMP command ? |
|
View Answer |
|
What is the use of PARFILE option in EXP command ? |
|
View Answer |
|
What is hit ratio ? |
|
View Answer |
|
What are the factors causing the reparsing of SQL statements in SGA? |
|
View Answer |
|
What is the significance of having storage clause |
|
View Answer |
|
What is the use of INDEXES option in EXP command ? |
|
View Answer |
|
How the space utilization takes place within rollback segments |
|
View Answer |
|
What are the four main functions of a memory manager? |
|
View Answer |
|
What is mean by Program Global Area (PGA) ? |
|
View Answer |