Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Database Logical & Physical Architecture 6

91. What is use of Rollback segments in Oracle database?
They allow the database to maintain read consistency between multiple transactions.

92. What is a rollback segment entry?
It is the set of before image data blocks that contain rows that are modified by a transaction.
Each rollback segment entry must be completed within one rollback segment.

A single rollback segment can have multiple rollback segment entries.

93. What is hit ratio?
It is a measure of well the data cache buffer is handling requests for data.
Hit Ratio = (Logical Reads - Physical Reads - Hits Misses)/ Logical Reads.

94. When will be a segment released?
When Segment is dropped.
When Shrink (RBS only)
When truncated (TRUNCATE used with drop storage option)

95. What are disadvantages of having raw devices?
We should depend on export/import utility for backup/recovery (fully reliable)
The tar command cannot be used for physical file backup, instead we can use dd command, which is less flexible and has limited recoveries.



This post first appeared on Java Interview Questions, please read the originial post: here

Share the post

Database Logical & Physical Architecture 6

×

Subscribe to Java Interview Questions

Get updates delivered right to your inbox!

Thank you for your subscription

×