| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is Database Buffers ? | | 2 |
| List the Optional Flexible Architecture (OFA) of Oracle
database ? | | 1 |
| What is Cursor? | | 2 |
| What is Shared SQL Area? | | 1 |
| Which parameter in Storage clause will reduce no. of rows
per block? | | 1 |
| What is the functionality of SYSTEM table space ? | | 2 |
| what is ORACLE MEMORY STRUCTURES | | 1 |
| How to implement the multiple control files for an existing
database ? | | 1 |
| How many Dispatcher Processes are created? | | 1 |
| What is the maximum number of Lock Processes used? | | 1 |
| What is Dedicated Server Configuration? | | 1 |
| How free extents are managed in Ver 6.0 and Ver 7.0 ? | IBM | 1 |
| What is meant by recursive hints ? | | 1 |
| How will you monitor rollback segment status ? | | 1 |
| what is the role of archiever | Satyam | 1 |
| How will you create multiple rollback segments in a
database ? | | 1 |
| What are the two types of Server Configurations? | | 1 |
| How will you swap objects into a different table space for
an existing database? | | 1 |
| What is a Parallel Server option in ORACLE? | | 1 |
| What is hit ratio ? | | 1 |
| |
| For more Architecture Interview Questions Click Here |