What are the steps involved in Instance Recovery ?
Answer / guest
Rolling forward to recover data that has not been recorded
in data files, yet has been recorded in the on-line redo
log, including the contents of rollback segments.
Rolling back transactions that have been explicitly rolled
back or have not been committed as indicated by the rollback
segments regenerated in step a.
Releasing any resources (locks) held by transactions in
process at the time of the failure.
Resolving any pending distributed transactions
undergoing a two-phase commit at the time of the instance
failure.
Is This Answer Correct ? | 4 Yes | 4 No |
Enlist the disadvantages of query.
State three differences between Dbms and Rdbms?
Have you written applications to retrieve stored images in a table?
What are the components of rdbms?
How does index hunting help in improving query performance?
What is flag in database?
What is Dedicated server configuration ?
Which database is best for storing large data?
What's the difference between delete and truncate ?
How to activate all indexes in firebird?
What is the data in a database?
What is pdo database?