Real Time Training - Week-1(Day 1 - 5)

    Day - 1
    S.No Title
    1 Shell Script Tasks Exercise (Tasks)
    2 Silent Mode Installation
    3 Tar ball installation
    4 Xming
    5 Fundamental Introduction
    6 Architecture
    7 SGA and PGA
    8 BG Process

    Day - 2

    S.No Title
    1 Query flow
    2 Parameter
    3 Startup and Shutdown
    4 pfile and spfile
    5 Exercise (Questions)

    Day - 3
    S.No Title
    1 Control file
    2 Log file
    3 Archive log file
    4 Exercise (Questions)

    Day - 4
    S.No Title
    1 Dbca Creation
    2 Manual db creation
    3 Exercise (Questions)

    Day - 5
    S.No Title
    1 Manage Tablespaces and Datafiles
    2 System / Sysaux
    3 Non-permanent
    4 pfile and spfile
    5 Exercise (Questions)

Interview Questions
1. List out 10 memory level parameters ?
2. Which commands leads to sorting? What memory area is used for sorting ? How will you increase the performance of sorting ? Name the parameters ?
3. What will happen if you give commit? What are the wait events that affect log buffer ?
4. What will happen if you give commit? What are the wait events that affect log buffer ?
5. What will happen if you give commit? What are the wait events that affect log buffer ?
6. How will you increase the size of library cache? What is hard and soft parse ?
7. What is checkpoint?How will reduce the checkpoint frequency ?
8. Explain the steps that involved when bringing up the database? How to drop the database? how to change the mode of database ?
9. Explain instance recovery? Who does instance recovery ? Where will you check whether the instance recovery happened or not ? What files were involved in the Instance recovery ?
10. Who read the data into memory ? How will you increase the performance of write
from DBBC to datafiles ?
11. What is difference between ORACLE_BASE and ORACLE_HOME ?
12. I have a 50 Unix servers, what is fastest method to install oracle ?
13. Why we need to execute root.sh ?
14. What is the prerequisite to install Oracle on Linux ?
15. How will you configure automatic startup and shutdown options ?
16. How will release memory from OS (or) When i restart the database i get unable to allocate shared memory segment ?

( Week - 2 (Day 6 - 10) )





Recent Videos | Today

Fragmentationm

Description about Fragmentationm

Oracle Installation

Description about Installation