| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the components of SGA? | | 1 |
| When Does DBWR write to the database? | | 4 |
| List the factors that can affect the accuracy of the
estimations ? | | 1 |
| What is a Rollback segment entry ? | TCS | 3 |
| What is meant by redo log buffer ? | | 1 |
| What is a Parallel Server option in ORACLE? | | 1 |
| How does Space allocation table place within a block ? | | 1 |
| What is the maximum number of Lock Processes used? | | 1 |
| How will you monitor the space allocation ? | | 2 |
| What is a Multi-threaded Server Configuration? | | 1 |
| What is the role of PCTFREE parameter is Storage clause ? | | 2 |
| What are functions of PMON? | | 2 |
| How to find the current session sid | | 2 |
| What is the significance of having storage clause ? | | 1 |
| What is meant by Redo Log file mirrorring ? How it can be
achieved? | | 1 |
| What does LGWR do? | | 1 |
| Which parameter in Storage clause will reduce no. of rows
per block? | | 1 |
| What is meant by free extent ? | | 2 |
| How will you monitor rollback segment status ? | | 1 |
| How can we plan storage for very large tables ? | | 1 |
| |
| For more Architecture Interview Questions Click Here |