DBA Questions

1. How you will recover Online redolog files?
2. If you lost your Control file lost how will you recover?
3. Users are complaining Concurrent paragram take time to complete?
4. What DMT and LMT? What is the difference between those?
5. How will u rebuild index for what purpose u will do?
6. How will create a user and how will assign a table space, quota to that user?
7. How will u dynamically set SGA in 9i, 10g?
8. How will set the sizes for shared pool, log buffer, large pool so on in SGA?
9. What is ADDM, AWR in 10G?
10. How will dynamically set the SGA in 10G?
11. Why we need to set kernel parameters for what purpose?
12. When creating database if you get error where will you check?
13. What is ORA-01000?
14 What is ORA-0060 ?
15. How to define Data Block size ?
16. What is the function of Optimizer ?
17. What is SAVE POINT ?
18.what is the use od root.sh script ?
19.What is the impact if I lose my dual table ?
20.How you identify the password for DB link in 9i ?