| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How will you estimate the space required by a non-clustered
tables? | | 1 |
| When does LGWR write to the database? | | 3 |
| How can we plan storage for very large tables ? | | 1 |
| List the Optional Flexible Architecture (OFA) of Oracle
database ? | | 1 |
| What is Shared Pool? | | 3 |
| what is ORACLE MEMORY STRUCTURES | | 1 |
| What are disadvanteges of having raw devices ? | | 1 |
| What is SGA? | | 1 |
| How will you swap objects into a different table space for
an existing database? | | 1 |
| What does LGWR do? | | 1 |
| Which parameter in Storage clause will reduce no. of rows
per block? | | 1 |
| How to find the SGA Size | | 2 |
| What are the two types of Server Configurations? | | 1 |
| What is advantage of having disk shadowing/ Mirroring ? | | 1 |
| What is the role of PCTFREE parameter is Storage clause ? | | 2 |
| What is the function of Lock (LCKn) Process? | | 1 |
| What is the functionality of SYSTEM table space ? | | 2 |
| What is the significance of having storage clause ? | | 1 |
| What is Dedicated Server Configuration? | | 1 |
| What is the function of Dispatcher (Dnnn)? | | 2 |
| |
| For more Architecture Interview Questions Click Here |