ALLInterview.com :: Home Page Forum9.Com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories >> Software >> Databases >> Oracle >> Architecture
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
Question
What is a Rollback segment entry ?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is a Rollback segment entry ?
Answer
# 1
this contains the commited and uncommited data stored in
rollback table space prior to 9i. in 9i, it is called as
undo table space.
 
Is This Answer Correct ?    0 Yes 0 No
Ravi Dutta
 
  Re: What is a Rollback segment entry ?
Answer
# 2
ROLLBACK SEGMENT OR UNDO SEGMENT IS THE AREA IN UNDO TABLE 
SPACE WHERE CHANGED OR NEW UNCOMMITTED DATA RESIDES.

WHEN WE COMMIT, UNDO SEGMENT DATA BECOME UNUSEABLE. BUT IT 
STILL RESIDES IN THE UNDO SEGMENT FOR 600 SECONDS.

TO REMOVE THE CONSITANCY ISSUE FROM ORACLE DB.
 
Is This Answer Correct ?    0 Yes 0 No
Manvendra
 
 
 
  Re: What is a Rollback segment entry ?
Answer
# 3
WHEN WE COMMIT, UNDO SEGMENT DATA BECOME UNUSEABLE. BUT IT 
STILL RESIDES IN THE UNDO SEGMENT FOR 900 SECONDS.

it is called undo retention period
 
Is This Answer Correct ?    0 Yes 0 No
Ravi
 
 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
What is PGA?  3
What are the two types of Server Configurations?  1
How to find the SGA Size  2
What is a Parallel Server option in ORACLE?  1
What is Shared SQL Area?  1
How will you monitor the space allocation ?  2
What are disadvanteges of having raw devices ?  1
What is the functionality of SYSTEM table space ?  2
Why query fails sometimes ?  1
When Does DBWR write to the database?  4
What is the function of Dispatcher (Dnnn)?  2
Name the ORACLE Background Process?  2
What is meant by redo log buffer ?  1
What is User Process?  1
Which parameter in Storage clause will reduce no. of rows per block?  1
What is the OPTIMAL parameter ? TCS1
How will you estimate the space required by a non-clustered tables?  1
How to implement the multiple control files for an existing database ?  1
What is a Rollback segment entry ? TCS3
How can we plan storage for very large tables ?  1
 
For more Architecture Interview Questions Click Here 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com