Real time Oracle DBA Interview Questions and Answers

Dear DBA-Mates,
Hope you all are doing Good!!! As per time constraint, not able to provide all the Answers but these are the some important Questions which are asked in Ci... MNC company... We will try to close all the answers slowly-slowly...
But for this time please go through the Questions and test yourself...

1) Rac Complete Configuration with prereq steps?

2)What is Voting disk and OCR File?

3) How u will take ocr Backup if u lost?

4)How to check the node connectivity? what is the script used for?

5)What are the advantages of ASM?

6)Why we use raw devices in ASM? can we use any other storage?

7)How to add redo logs in ASM?

8) How many Undo required in RAC?

9)Benefits of RMAN Backups

10)Have u clone RAC to Non RAC?

11)Clone of RAC to RAC..Tell me the difference?

12)Patching on Distributed AD?

13) Tell me some workflow background process?

14)How to generate DBC file?

15)For Discoverer What is required to set the profile?

16)SSO,OID ..u know?

17)U know Weblogic?

18)U know SOA, Application server?

19)what all the ad utilities u used ?

20)What are the different Status of Worker?

21)U know about events?

22)Let me different Ad options?

23)Flow of apps when u login ?

24)What is the use of DBC File and Tnsnames.ora

what is the difference here...both used for connectivity?

25)PCP Concepts ..how to implement?

26)where do you increase the process for a concurrent Manager

for standard manager?

27)Let the Major difference for 11i and R12?

28)Upgrade process 11.5.9 to R12?

29)How to you licence a product? what is the purpose of adsplice? what is the difference of the both?

30)Have u applied HRMS or Legislative Patches?

31)RAC node ,How do you patch?

32)RAC to Non RAC Clone? Explain and what are the major difference?

33)What exactly happens when any user connect to database?

34)How many undo's required in RAC?

35)What is $TWO_TASK

36)You do Rman Clones?

37)How to do save customizations, What u run autoconfig?

38)How to configure JVM?

39)What is JVM?

40)Have u faced any performance issues After upgrade?

41)what are the services running in R12(1st node - CM and DB

and 2nd node - web and forms

42)Custom_code Creation Steps

43) What are the things that can be done on OAM?

44) Mention some Workflow Tables?

45)why u rebuild workflow tables ?and How?

46)10g Discoverer can be configured on 11?
Hope this may useful...
Regards,