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
|Is This Answer Correct ?||4 Yes||4 No|
How to repair a corrupt firebird database?
Explain what are the two types of oltp?
Enlist the advantages of normalizing database.
How does distributed database work?
What is concurrency control?
Can A column defined as PRIMARY KEY can have NULL values ?
Explain the importance of partitioning.
If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?
How do I create a database in access 2010?
1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?
can Constraints cannot be exported through EXPORT command ?
What are queries in dbms?