Interview Questions

1. What is Scattered read & sequential read
2. How to take a trace of running session.
3. What are levels of trace
4. What are the advantages Materialized view
5. Upgrade process from 8i to 9i, what are mandatory parameters needs to be changed in init file,
6. New features in 9i.
7. Algorithm used in undo mgnt
8. What is snapshot too old error (ORA - 1555).
9. LMT and Dictionary mnged t/s. What is Auto Space Management.
10. How to create a T/s and the parameters involved
11. What are resetlogs and what happens when we do noresetlogs.
12. Process for applying CPU Patches (Critical Patch Updates)
13. How to apply RDBMS patches.
14. How to read tkprof and what information will you provide to the users.
15. What is instance level trace.
16. AOLJ test and other test invloved for troubleshooting details.
17. What needs to be checked in logs of apache and modjserv
18. what is novalidate in patching
19. Explain the key points of the upgrade of 11.5.7 ~ 11.5.10 E-Business Suite.
20. Importance of TUMS patch during the upgrade.
21. How to reduce the time of upgrade process.
22. Name few Init.Ora parameters modified after DB upgrade
23. Explain few post cloning steps.
24. Main scripts run during SSO implementation to register EBS with login server.
25. How time it took to migrate the DB of size 2 TB into OATM model. Is there any challenges faced.