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 |
What is super key in dbms?
What are the restrictions applicable while creating views?
What are the 4 types of database?
Name the different data models that are available for database systems.
How do databases help businesses?
If you need to refresh a website page every time a record is updated in database, how would you do it?
What is the use of PARFILE option in EXP command ?
What are different relationships existing in database?
What is actional flow mapping?
What are the database objects?
Define database model.
What are notification services?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)