Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
From where does PMON gets the conformance about failure? How is the user process terminated?
Answer:
When user process is terminated abruptly due to power cut or any other factors then oracle database instance goes down then PMON mandatory background process is activated i.e it will then writes the commited data into respective datafiles which we can call this process as rollforward. if the data is not commited then by the action of rollbackword it erases the data from datafiles.
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
Previous Question | Next Question |
What is a View in Oracle? | What is SID (System Identifier)? |