| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the functions of SMON? | | 2 |
| What are the components of SGA? | | 2 |
| What is Server Process? | | 1 |
| What are disadvanteges of having raw devices ? | | 1 |
| What is Shared SQL Area? | | 1 |
| what is the role of archiever | Satyam | 1 |
| What Does DBWR do? | | 2 |
| How will you swap objects into a different table space for
an existing database? | | 1 |
| What is PGA? | | 3 |
| How will you estimate the space required by a non-clustered
tables? | | 1 |
| When does LGWR write to the database? | | 3 |
| What do Redo Log Buffers contain? | | 1 |
| When Does DBWR write to the database? | | 4 |
| What is Shared Pool? | | 3 |
| How many Dispatcher Processes are created? | | 1 |
| What is advantage of having disk shadowing/ Mirroring ? | | 1 |
| Name the ORACLE Background Process? | | 2 |
| What is meant by free extent ? | | 2 |
| What is use of Rollback Segments In Database ? | | 2 |
| How can we plan storage for very large tables ? | | 1 |
| |
| For more Architecture Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
