Need detail reply of APPS DBA interview questions

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
amirtai
Posts: 138
Joined: Sat Apr 08, 2006 5:54 pm
Location: Canada
Contact:

Need detail reply of APPS DBA interview questions

Post by amirtai »

Q1. What is wdbsvr.app file used for? What's full path of this file? What's significance of this file ?

Q2. Where would i find .rf9 file, and what execatly it dose ?

Q3. Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why its used?

Q4. Can you clone from multi node system to single node system & vice versa ?

Q5. What is .dbc file , there are lot of dbc file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ?

Q6. Whats things you do to reduce patch timing ?

Q7. Can you apply patch without putting Applications 11i in Maintenance mode ?

Q8. adident utility is used for what ?

Q9. How can you licence a product after installation ?

Q10. What is MRC ? What you do to enable MRC in Apps ?

Q11. What is access_log in apache , what entries are recored in access_log ? Where is default location of thsi file ?

Q12. What is session time out parameter & where all you define these values ?

Q13. Where is applications start/stop scripts stored ?

Q14. What are main configuration files in Web Server (Apache) ?

Q15. How to check if Apps 11i System is Autoconfig enabled ?

Q16. How to check if Oracle Apps 11i System is Rapid Clone enabled ?

Q17. What is plssql/database cache?

Q18. How to determine Oracle Apps 11i Version ?

Q19. What is RRA/FNDFS ?

Q20. What is PCP in Oracle Applications 11i ? In what scenarios PCP is Used ?

Q21. Output & Logfiles for requests executed on source Instance not working on cloned Instance

Q22. How to confirm if Report Server is Up & Running ?

Q23. What is difference between ICM, Std Managers & CRM in Concurrent Manager ?

Q24. What is use of Apps listener ? How to start Apps listener ? How to confirm if Apps Listener is Up & Running ?

Q25. What is Web Listener ?

Q26. How will you find Invalid Objects in database ? How to compile Invalid Objects in database ?

Q27. How to compile JSP in Oracle Apps ?

Q28. What is difference between adpatch & opatch ? Can you use both adpatch & opatch in Apps ?

Q29. Where will you find forms configuration details apart from xml file ? What is forms server executable Name ?

Q30. What are different modes of forms in which you can start Forms Server and which one is default ?

Q31. How you will start Discoverer in Oracle Apps 11i ?

Q32. How many ORACLE HOME are Oracle Apps and whats significance of each ?

Q33. Where is HTML Cache stored in Oracle Apps Server ?

Q34. Where is plssql cache stored in Oracle Apps ?

Q35. What happens if you don't give cache size while defining Concurrent Manager ?

Q36. How many ORACLE HOME are Oracle Apps and whats significance of each ?

Q37. Where is HTML Cache stored in Oracle Apps Server ?

Q38. What are few profile options which you update after cloning ?

Q39. How to retrieve SYSADMIN password ?

Q40. If you have done two node Installation, First machine : Database and concurrent processing server. 2nd machine: form,web Which machine have admin server/node?

Q41. What is GWYUID, Where GWYUID defined & what is its used in Oracle Applications ?

Q42. Whats is TWO_TASK in Oracle Database ?

Q43. What is difference between GUEST_USER_PWD (GUEST/ORACLE) & GWYUID ?

Q44. How to check number of forms users at any time ?

Q45. What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD ?

Q46. In a Multi Node Installation, How will you find which node is running what SErvices ?

Q47. If your system has more than one Jinitiator, how will the system know, which one to pick. ?

Q48. While applying Apps patch using adpatch, if you want to hide the apps password, how will that be possible ?

Q49. What is importance of IMAP Server in Java Notification Mailer ?

Q50. What is difference between Socket & Servlet Mode in Apps Forms ?

Q51. a. How to find OUI version ?
b. How to find Database version ?
c. How to find Oracle Workflow Cartridge Release Version ?
d. How to find opatch Version ?
e. How to find Version of Apps 11i ?
f. How to Discoverer Version installed with Apps ?
g. How to find Workflow Version embedded in Apps 11i ?
h. How to find version of JDK Installed on Apps ?

Q52. Q. If by mistake you/someone deleted FNDLIBR can this executable be restored if Yes, How & if no, what will you do ?

Q53. What is .pls files which you see with apps ?

Q54. What are .ldt & .lct files which you see in apps patch or with FNDLOAD ?

Q55. What are .odf file in apps patch ?

Q56. What to find Form Server log files in forms ?

Q57. How to convert pll to pld file or pld file to pll ?

Q58. Is APPS_MRC Schema exists for MRC in 11.5.10 and higher ?

Q59.If APPS_MRC schema is not used in 11.5.10 and higher then How MRC is working ?

Q60. When you apply C driver patch does it require database to be Up & Why ?

Q61. Can C driver in apps patch create Invalid Object in database ?

Q.62 Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you ?

Q63. What is dev60cgi & f60cgi ?

Q64. What is difference between mod_osso & mod_ose in Oracle HTTP Server ?
Q65. What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms ?

Q66. What is ps -ef or ps command in Unix ? for work ex < 1 yr

Q67. What is GSM in Oracle application E-Business Suite ?

Q68. What is FNDSM ?

Q69. What is iAS Patch ?

Q70. If we run autoconfig which files will get effected ?
Q71. What is difference between .xml file & AutoConfig ?
Q72. What is .lgi files ?
Q73. How will you skip worker during patch ?

Q74. Which two tables created at start of Apps Patch & drops at end of Patch ?
Q75. How to compile an Oracle Reports file ?

Q76. What is difference between AD_BUGS & AD_APPLID_PATCHES ?

Q77. What exactly happens when you put an Oracle Apps instance in maintenance mode ?

Q78. What is profile options, What are various type of profile options ?

Q79. If users complaining Oracle Applications 11i system is running slow , what all things you will check at broad level ?

Q80. Why appsutil directory under Database ORACLE_HOME used for ?

Q81. How to create User in Oracle Applications 11i ? Can you delete a User ?

Q82. What is Single Sign On ? ( If you are using portal 3.0.9 or 10G )?

Q83. How to configure portal with 11i ? ( If you are using portal 3.0.9 or 10G )?

Q84. What is content of dbc file & why its important ?
padhi_bk
Posts: 2
Joined: Thu Mar 15, 2007 5:07 am
Location: India

Post by padhi_bk »

HI
Have you checked teachmeoracle.com

Birendra
Oracle Apps Administrator
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests