Faltu Funda| 30 Mar 2008 | |||||
|---|---|---|---|---|---|
|
practice interviews and prepare for interviews in todays changing world every one want to increase there salaries very quickly. Changes your employer is an very efficient solution for this. But changing employer and company is not so easy. cont.. |
||||
| 04 Apr 2008 | |||||||
|---|---|---|---|---|---|---|---|
|
Interview question for Oracle dba Here are a few sample question that can be asked for a position of dba for oracle database
1. What is an Oracle Instance? 2. What information is stored in Control File? 3. When you start an Oracle DB which file is accessed first? 4. What is the Job of SMON, PMON processes? 5. What is Instance Recovery? 6. What is written in Redo Log Files? 7. How do you control number of Datafiles one can have in an Oracle database? 8. How many Maximum Datafiles can there be in an Oracle Database? 9. What is a Tablespace? 10. What is the purpose of Redo Log files? 11. Which default Database roles are created when you create a Database? 12. What is a Checkpoint? 13. Which Process reads data from Datafiles? 14. Which Process writes data in Datafiles? 15. Can you make a Datafile auto extendible. If yes, how? 16. What is a Shared Pool? 17. What is kept in the Database Buffer Cache? 18. How many maximum Redo Logfiles one can have in a Database? 19. What is difference between PFile and SPFile? 20. What is PGA_AGGREGRATE_TARGET parameter? |
||||||
|
|
![]() |
|
||
|
||||
|
|
![]() |
|
||