| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is meant by recursive hints ? | | 1 |
| How the space utilisation takes place within rollback
segments? | | 1 |
| What is a Multi-threaded Server Configuration? | | 1 |
| What is function of RECO? | | 1 |
| What is Dedicated Server Configuration? | | 1 |
| How to find the current session sid | | 2 |
| What are disadvanteges of having raw devices ? | | 1 |
| How will you monitor the space allocation ? | | 2 |
| What are the components of SGA? | | 2 |
| What are the functions of SMON? | | 2 |
| What is Server Process? | | 1 |
| Name the ORACLE Background Process? | | 2 |
| What is meant by Redo Log file mirrorring ? How it can be
achieved? | | 1 |
| what is the role of archiever | Satyam | 1 |
| How many Dispatcher Processes are created? | | 1 |
| What is the maximum number of Lock Processes used? | | 1 |
| What is dictionary cache ? | | 2 |
| What is a Rollback segment entry ? | TCS | 3 |
| What is hit ratio ? | | 1 |
| What is Database Buffers ? | | 2 |
| |
| For more Architecture Interview Questions Click Here |