CONCEPTS NEED TO COVER FOR INTERVIEW ORACLE DBA

------------------------------------------------------------------------------------------------------------------------------|
|CONCEPTS NEED TO COVER FOR INTERVIEW                                                                                         |
|-----------------------------------------------------------------------------------------------------------------------------|
|1. Introduce about yourself                                                                                                  |
|2. Day to day activities       |
|3. ticketing tool, process, shifts, shift handover       |
|4. Oracle architecture 10G,11G,12C       |
|5. backups and the types               |
|   5.1 logical backup       |
|   5.2 physical backup       |
|   5.3 exp,expdp imp,impdp uses ,parameters,differences       |
|   5.4 cold& hot backups uses, differences, advantages and disadvantages       |
|6. RMAN with details including commands, uses , configuration,       |
|7. Recovery using RMAN       |
|8. Recovery using different types of backups       |
|9. cloning using different types of backups uses advantages       |
|10. patching , types of that advantages disadvantages all parameters       |
|11. upgradation details               |
|12. dataguard--> physical, logical and manual types with details syncing, switchover failover       |
|13. performance tuning       |
|14. Issues faced with details       |
|15. Listener configuration issues regarding that       |
|16. SQLLOADER, dblink, logminer       |
|17. User level       |
|18. Installation of oracle       |
|19. OEM, TOAD,       |
|20. ASM, RAC                               |
|21. SQL, PL/SQl, AWS, Linux and windows OS architecture               |      
|       |
-------------------------------------------------------------------------------------------------------------------------------