| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is Shared SQL Area? | | 1 |
| What is advantage of having disk shadowing/ Mirroring ? | | 1 |
| List the factors that can affect the accuracy of the
estimations ? | | 1 |
| Name the ORACLE Background Process? | | 2 |
| what is the role of archiever | Satyam | 1 |
| What is Cursor? | | 2 |
| How does Space allocation table place within a block ? | | 1 |
| How will you monitor rollback segment status ? | | 1 |
| What is dictionary cache ? | | 2 |
| How many Dispatcher Processes are created? | | 1 |
| What is Server Process? | | 1 |
| What is SGA? | | 1 |
| How can we plan storage for very large tables ? | | 1 |
| What is hit ratio ? | | 1 |
| What is Dedicated Server Configuration? | | 1 |
| What is a Control file ? | | 2 |
| What are functions of PMON? | | 4 |
| What is Shared Pool? | | 3 |
| What is a Rollback segment entry ? | TCS | 3 |
| Which parameter in Storage clause will reduce no. of rows
per block? | | 1 |
| |
| For more Architecture Interview Questions Click Here |
Site Map
