When a user updated a particular table (for example 100 rows) the old value will be retained in the roll back segments(Oracle 8) and now it is Undo segment (oracle 9i). If the user issue a rollback command the old value will be taken from the rollback segment(that too if undo_retention parameter set properly in the parameter file).
What is a Data Segment in Oracle?
Can we add a column to view in Oracle?
Which parameter specifies the number of DBWn processes?
What is the use of archive log file?
How to apply archive log file in Oracle?
How does archive log file helps to make backup consistent?
What is schema in Oracle Architecture?
Where does the process dumps information about the error?
What is the use of Redo Log Information in Oracle?
Explain Virtual tables?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
