| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the role of archiever | Satyam | 1 |
| What is Cursor? | | 2 |
| What is the function of Lock (LCKn) Process? | | 1 |
| What is Server Process? | | 1 |
| What are the components of SGA? | | 2 |
| What does LGWR do? | | 1 |
| What is User Process? | | 1 |
| What is the function of ARCH? | | 1 |
| What are functions of PMON? | | 3 |
| How to find the current session sid | | 2 |
| How will you estimate the space required by a non-clustered
tables? | | 1 |
| What is the function of Dispatcher (Dnnn)? | | 2 |
| How will you swap objects into a different table space for
an existing database? | | 1 |
| Name the ORACLE Background Process? | | 2 |
| How the space utilisation takes place within rollback
segments? | | 1 |
| What is advantage of having disk shadowing/ Mirroring ? | | 1 |
| How does Space allocation table place within a block ? | | 1 |
| When Does DBWR write to the database? | | 4 |
| How will you force database to use particular rollback
segment? | | 1 |
| How to implement the multiple control files for an existing
database ? | | 1 |
| |
| For more Architecture Interview Questions Click Here |