| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What Does DBWR do? | | 2 |
| What is the function of Lock (LCKn) Process? | | 1 |
| How will you force database to use particular rollback
segment? | | 1 |
| How the log writer writes the data into database | Satyam | 1 |
| How free extents are managed in Ver 6.0 and Ver 7.0 ? | IBM | 1 |
| List the Optional Flexible Architecture (OFA) of Oracle
database ? | | 1 |
| What is Server Process? | | 2 |
| What is a Parallel Server option in ORACLE? | | 1 |
| What is the role of PCTFREE parameter is Storage clause ? | | 2 |
| How does Space allocation table place within a block ? | | 1 |
| How will you monitor rollback segment status ? | | 1 |
| How can you find the size of a database? | HCL | 1 |
| What is meant by Redo Log file mirrorring ? How it can be
achieved? | | 1 |
| What is dictionary cache ? | | 2 |
| How can we plan storage for very large tables ? | | 1 |
| What is meant by recursive hints ? | | 1 |
| What are disadvanteges of having raw devices ? | | 1 |
| What is function of RECO? | | 1 |
| How to find the current session sid | | 2 |
| What is a Multi-threaded Server Configuration? | | 1 |
| |
| For more Architecture Interview Questions Click Here |