| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the components of SGA? | | 2 |
| what is ORACLE MEMORY STRUCTURES | | 1 |
| What is Cursor? | | 2 |
| How can we plan storage for very large tables ? | | 1 |
| Which parameter in Storage clause will reduce no. of rows
per block? | | 1 |
| What is advantage of having disk shadowing/ Mirroring ? | | 1 |
| What is the maximum number of Lock Processes used? | | 1 |
| What are disadvanteges of having raw devices ? | | 1 |
| What do Redo Log Buffers contain? | | 1 |
| How will you monitor the space allocation ? | | 2 |
| What is meant by free extent ? | | 2 |
| What is User Process? | | 1 |
| How free extents are managed in Ver 6.0 and Ver 7.0 ? | IBM | 1 |
| When does LGWR write to the database? | | 3 |
| What is Dedicated Server Configuration? | | 1 |
| What is the functionality of SYSTEM table space ? | | 2 |
| How does Space allocation table place within a block ? | | 1 |
| What is the role of PCTFREE parameter is Storage clause ? | | 2 |
| How will you create multiple rollback segments in a
database ? | | 1 |
| What is meant by redo log buffer ? | | 1 |
| |
| For more Architecture Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
