| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How will you create multiple rollback segments in a
database ? | | 1 |
| Which parameter in Storage clause will reduce no. of rows
per block? | | 1 |
| What is function of RECO? | | 1 |
| What is a Multi-threaded Server Configuration? | | 1 |
| What are the components of SGA? | | 1 |
| How free extents are managed in Ver 6.0 and Ver 7.0 ? | | 1 |
| What do Redo Log Buffers contain? | | 1 |
| How to find the SGA Size | | 2 |
| What are the functions of SMON? | | 1 |
| What is PGA? | | 3 |
| What is meant by Redo Log file mirrorring ? How it can be
achieved? | | 1 |
| How to find the current session sid | | 2 |
| When will be a segment released? | | 1 |
| What is advantage of having disk shadowing/ Mirroring ? | | 1 |
| What is the function of ARCH? | | 1 |
| What is a Control file ? | | 2 |
| Name the ORACLE Background Process? | | 2 |
| How will you estimate the space required by a non-clustered
tables? | | 1 |
| What are disadvanteges of having raw devices ? | | 1 |
| How to implement the multiple control files for an existing
database ? | | 1 |
| |
| For more Architecture Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map