| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is PGA? | | 3 |
| What is a Parallel Server option in ORACLE? | | 1 |
| What are the components of SGA? | | 2 |
| How many Dispatcher Processes are created? | | 1 |
| When Does DBWR write to the database? | | 4 |
| What is a Control file ? | | 2 |
| How to find the current session sid | | 2 |
| What do Redo Log Buffers contain? | | 1 |
| What is meant by redo log buffer ? | | 1 |
| What is Dedicated Server Configuration? | | 1 |
| How will you force database to use particular rollback
segment? | | 1 |
| How free extents are managed in Ver 6.0 and Ver 7.0 ? | IBM | 1 |
| How will you swap objects into a different table space for
an existing database? | | 1 |
| What is a Rollback segment entry ? | TCS | 3 |
| What are the two types of Server Configurations? | | 1 |
| What is Cursor? | | 2 |
| Why query fails sometimes ? | | 1 |
| What does LGWR do? | | 1 |
| What Does DBWR do? | | 2 |
| What are the functions of SMON? | | 2 |
| |
| For more Architecture Interview Questions Click Here |