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 ?

Apps DBA Questions

1. What is a snapshot? In which table we get Information?
2. How will check Apache is working in Front-end and Back End
3. Write down the methods to identify whether the application is in maintenance mode or not
4. What is the result of unsetting APPLCSF
5. How are the AOL Developers Environment variables set
6. How do we get access to the initial sigon to application?
7. From where are the Report files picked up for execution
8. Where are the Reports plsql files located
9. Which ORACLE HOME is used by ad utilities
10. Which file contains the product dependencies information
11. When apps password is given wrong for adstpall.sh, what is the effect on the services
12. What are the Various Statuses of Workers
13. How do you restart a failed patch process
14. What are the table/tables created when workers are initiated and in which schema
15. Create defaults file for "Compile Apps Schema"
16. Execute "Compile Apps Schema" in noninteractive mode
17. Where are the custom files placed
18. Difference between ad_bugs and ad_applied patches
19. What happened Relink adslpice and adpatch?
20. What are Oracle Apps DBA Important Tables we use in daily activities?
21. What is .lct and .ldt files in Patch Directory?
22. What are the tables updated when you apply application patch?
23. Can you apply Opatch without inventory? If there is no inventory, how do you apply Opatch?
24. What are the tables get created during Apps Patching?
25. How do you hide apps password during adpatching? (adpatch flags=hidepw)
26. What is interoperability patch
27. How do you compile jsp files?
28. Types of profile options?
29. Opatch log file location?
30. How do you clone a context file or how do you change existing port pool?
31. How do you run autoconfig in test mode?
32. What are mandatory users in oracle apps?
33. What is the location of apache and plsql cache?
34. What is adlicmgr ?
35. When do you relinking?
36. What is DAD?
37. How do you compile a schema?
38. What is the utility to clean the concurrent manager tables?
39. How do you stage the 11.5.10 Apps software?
40. ADPATCH has failed and it indicated there was an error with a worker. What steps can be taken to investigate this problem?
41. How can I check to see if a concurrent manager is running?
42. Where do concurrent request or manager logfiles and output files go?
43. What is the function of the 'Conflict Resolution Manager'?
44. Unable to Bring Up Concurrent Manager after Running Autoconfig.
45. When should I run AutoConfig?
46. Which files / profile options get changed when I run AutoConfig?
47. What is cloning?
48. How do I determine if my system is Rapid Clone enabled?
49. Can I clone from one operating system version to another?
50. Can I change the database dbf files layout while cloning?
51. What is the difference between Concurrent Requests, Programs, and Processes
52. What is iAS Patch?
53. Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you?
54. When you apply C driver patch does it require database to be Up & Why?
55. What are the important options to reduce patch down time?
56. Can you apply patch without putting Applications 11i in Maintenance mode?
57. What is difference between adpatch & opatch? Can you use both adpatch & opatch in Apps?
58. Why do I have invalid objects? What causes them? How you identify them ?
59. Is there a file that lists all of the patches that have been applied to the application?
60. What is the difference between apps listener & web listener?
61. Why only for Concurrent Manager, we specify apps/apps password & not for other?
62. What’s the significance of batch size? What r the effects when we increase r decrease the batch size it defaults to 1000.
63. What is the purpose of using the option Phtofile in adpatch?
64. How do I configure AutoConfig for a multi-node system?
65. How do you identify the No. of nodes in Middle tier and db Tier
66. What is a Shared APPL_TOP? How do you identify whether it is a shared appl_TOP or not?
67. What is a Jinitiator? (Jinitiator is the Oracle JVM used to run the applet instead of using browsers own JVM)
68. Where would i find .rf9 file, and what exactly it dose?
69. What is .dbc file, where its stored , what’s use of .dbc file ?
70. What is the use of adident utility ?
71. What is adsplice utility ?
72. How can you licence a product after installation ?
73. What is access_log in apache , what entries are recored in access_log ? Where is default location of this file ?
74. How to determine Oracle Apps 11i Version ?
75. What is PCP is Oracle Applications 11i ?
76. How to convert pll to pld file or pld file to pll ?
77. Where are the Application usrs details stored?
78. How to find plsql version?
79. When do you use startmgr.sh script? Where its locate?
80. What is the yellow Bar Issues?

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.

Apps Dba Quections

1. What are the several techniques used in patching to reduce the downtime..?
2. Explain autoconfig in detail n what it will do in backgrond n what files it will look.?
3. In what scenario you will run autoconfig ?
4. what happened when u run adpreclone.pl ?
5. Explain apps request flow ?
6. What do you mean Purging Concurrent request log , out files n data ?
7. What is the significance of age parameter in that request ?
8. How u will improve the applications performance ?
9. Users complaining about applications are running very slow, how u will handle?
10. When users are failing to login to applications, what might be the problem ?
11. What is diff between 9i and 10g ?
12. Why objects are invalid and how to identify ?
13. What happens when u open the database with RESETLOGS n when u will do ?
14. I am applying OPatch I don't have oraInventory ?can I apply ?
15. How many concurrent mangers can be used ? What is the limit?
16. Suppose my concurrent manager status is showing Inactive ?what is the reason?
17. If a patch is failed in the middle of the patch?I don't want to apply the patch continue?
18. My cloning is successfully completed but my appslistener is not getting up?what is the problem?
19. How frequently you do perform patching?
20. What is the purpose of the appsutil folder in ORACLE_HOME?
21. After cloning my oraInventory got corrupted ?can I apply my Opatch?
22. What command is used to kill the process which is using largest memory?
23. I am applying patch can I open another session and run adadmin
24. I am not able to start concurrent manager?what is the probelm?
25. After registering the top in custom directory?Do you to run autoconfig are not?