What is Rollback Segment ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
A Database contains one or more Rollback Segments to
temporarily store "undo" information.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gvmahesh
roll back segment means it is a an dynamic memory location
for storing all the transactional(INSRT,UPDATE,DELETE) data.
untill we commited or rollback that data.
| Is This Answer Correct ? | 2 Yes | 0 No |
How can you Enforce Referential Integrity in snapshots ?
How many types of segments in Oracle?
what is pragma?
What is the recommended interval at which to run statspack snapshots, and why?
Is oracle an operator?
What is an Integrity Constrains ?
What is the maximum number of CHECK constraints that can be defined on a column ?
Define Transaction ?
Difference between the “verify” and “feedback” command?
What does sharding mean?
What privilege is needed for a user to delete rows from tables in another schema?
Can the query output be sorted by multiple columns in oracle?