| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How will you estimate the space required by a non-clustered
tables? | | 1 |
| What is use of Rollback Segments In Database ? | | 2 |
| List the Optional Flexible Architecture (OFA) of Oracle
database ? | | 1 |
| What is Database Buffers ? | | 2 |
| How will you force database to use particular rollback
segment? | | 1 |
| What is the function of ARCH? | | 1 |
| What is SGA? | | 1 |
| What is advantage of having disk shadowing/ Mirroring ? | | 1 |
| How will you monitor rollback segment status ? | | 1 |
| What is Server Process? | | 1 |
| What is meant by free extent ? | | 2 |
| How will you monitor the space allocation ? | | 2 |
| What is function of RECO? | | 1 |
| What are the two types of Server Configurations? | | 1 |
| What is a Rollback segment entry ? | TCS | 3 |
| What is meant by Redo Log file mirrorring ? How it can be
achieved? | | 1 |
| Name the ORACLE Background Process? | | 2 |
| What is meant by recursive hints ? | | 1 |
| When Does DBWR write to the database? | | 4 |
| What is a Parallel Server option in ORACLE? | | 1 |
| |
| For more Architecture Interview Questions Click Here |