What are the steps involved in Instance Recovery?
Submitted by: AdministratorRolling 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.
1) Releasing any resources (locks) held by transactions in process at the time of the failure.
2) Resolving any pending distributed transactions undergoing a two-phase commit at the time of the instance failure.
Submitted by: Administrator
1) Releasing any resources (locks) held by transactions in process at the time of the failure.
2) Resolving any pending distributed transactions undergoing a two-phase commit at the time of the instance failure.
Submitted by: Administrator
Read Online Data Warehousing Job Interview Questions And Answers
Top Data Warehousing Questions
☺ | What is the difference between aggregate table and materialized view? |
☺ | "A dimension table is wide but the fact table is deep," Explain the statement in your own words. |
☺ | What is the advantages data mining over traditional approaches? |
☺ | What are data validation strategies for data mart validation after loading process? |
☺ | Can you pass sql queries in filter transformation? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |