| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the two types of Server Configurations? | | 1 |
| What is the OPTIMAL parameter ? | TCS | 1 |
| What are the components of SGA? | | 2 |
| Why query fails sometimes ? | | 1 |
| What is SGA? | | 1 |
| How does Space allocation table place within a block ? | | 1 |
| What is meant by free extent ? | | 2 |
| What are disadvanteges of having raw devices ? | | 1 |
| How many Dispatcher Processes are created? | | 1 |
| When Does DBWR write to the database? | | 4 |
| What is Database Buffers ? | | 2 |
| What is the function of Lock (LCKn) Process? | | 1 |
| What is a Control file ? | | 2 |
| What Does DBWR do? | | 2 |
| What is the function of checkpoint(CKPT)? | | 1 |
| What is a Multi-threaded Server Configuration? | | 1 |
| How will you create multiple rollback segments in a
database ? | | 1 |
| What are functions of PMON? | | 4 |
| What is Server Process? | | 1 |
| What is the functionality of SYSTEM table space ? | | 2 |
| |
| For more Architecture Interview Questions Click Here |