Real Time Oracle Apps DBA Interview Questions

Dear DBA-Mates,
Hope you all are doing Good!!!
We understand that finding answers of these Questions is not easy for freshers but sorry due to lack of time, we are not able to prepare the Answers for all the below Questions.But these all are the asked question's in interview.

But please do some research, you will get it all. And doing research is a DBA's main task. So, please keep reading and sharing the Answers also...

1)Let me the flow of application when user login?

2)What is the purpose of authentication to connect to database?

3)Why u need GUEST/ORACLE To connect to database?

4)What is the purpose of JSERV?

5)How to increase the performance of Apache?

6)Tell me some issues with Apache?

7)Why u need httpd.pid?why u need to clear that?

10)If One dba can launch the forms and another unable to launch

the forms?what will be the issue?

11)How to set trace at forms level?

12)If u have Concurrent request with pending -standby

how do your troubleshoot?

13)If you have long pending requests and system become slow.what you do?

14)If you lost http.conf file, without running autoconfig to create all files,I want to generate only http.conf individually?

15)How autoconfig works?

16)what Concurrent Tables that will cleanup when u run cmclean.sql?

17)PCP configuration ?What is the principal behind it? how to u

configured?

18)What is diff between distributed AD and Shared Appl_top? what happens when u apply patch and distributed AD and Shared Appl_top?

19)What happen if you Miss Pre-Req patch and apply main patch

and how to do continue?

20)How to do u skip a worker

21)How to u recover if u lost a single file.

22)Explain how Dataguard works?what is the principal behind that?

23)what are different Session waits?

24)How do you check Blocking sessions?

25)Have u common across ora-600 errors?what is the cause of errors?

26)What are the different Events?

27)What are systemstat event Stand for?

28)What is the main purpose of maintenance Mode?

29)What if Apache is up when Maintenance Mode is up?

30)What is heap size?

31)Issues u faced with concurrent Managers?

32)What is the script u used to clean the FND_NODES of the

production Entries on non-Prod Entries.

33)How you mount the production Snap to target without putting the prod in begin backup mode?

34)How to check port Availability?

35)How do you Save time while doing patching?

36)What is the purpose of Defaults File?

37)Where do your increase processes for a concurrent Manager?

38)Wait Events? Different Wait events u have come across and what all the solution u have given to them?

39)How to check Port Availability?

40)How do you save time while doing patching?

41)Have u worked on workflow issues?

42)In Rac How do you do patching?

43)How do you check for conflicts with database patching?

44)What is the purpose of APPS,APPLSYS,APPLSYSPUB,At the login?

45)What happens when u put in database in begin backup mode?

46)why more redo's are generated?

47)Is the Datafile Will update when headers are freeze?

48)what actions can perform on datafiles when headers are freeze?

49)If you have 10 archive logs, How to find how many archives are required to complete the recovery?

50)Have u come across any ora-600 errors?

Hope this may useful and helpful.
Regards,