« Technical Interview & Viva Questions : KyaPoocha.com home page
« What is a Rollback segment entry?
What are disadvantages of having raw devices? »



What a hit ratio?


When Segment is dropped.
When Shrink (RBS only)
When truncated (TRUNCATE used with drop storage option)



Explore posts in the same categories: SQL Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • In a country in which people only want boys, every family continues to have children until they have a boy. if they have a girl, they have another child. if they have a boy, they stop. what is the proportion of boys to girls in the country?
    • Assuming both having a boy or a girl are equal in probability then the ratio is 1....
  • How would you go about increasing the buffer cache hit ratio?
    • Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary...
  • How many times a day a clock’s hands overlap?
    • In any circular motion, if the ratio between 2 fellow is n:1 then for each lap of the slower fellow,...
  • General Programming and IQ based Questions
    • These questions are used on written exam by Indian contractor Wipro for job applicants in India. John weighs twice as much...
  • DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
    • A merge join requires that the tables being joined be in a sequence; the rows are retrieved with a high...

    Comments are closed.