Just Crack Interview

Oracle interview questions

1,328 questions. Tap “Show answer” to check yourself.

Advertisement

  1. Physical standby database

  2. Backup and Recovery techniques including cold and hot backup

  3. Oracle Architecture - Shared Pool and SGA

  4. Cursors,autonomous transaction, Mostly on java

  5. About my OCA and OCP Certifications

  6. The Users are not able to save the data, as a BASIS ADMIN meto not able to save, what is the problem would be..?

  7. What is BDC?

  8. ORA-06535: statement string in string is NULL or 0 length

  9. ORA-23421: job number string is not a job in the job queue

  10. What is the purpose of standard cost update?

  11. In my table i'm having the duplicate records with sequencenumber and my requirement is when in new record is coming iwant to delete existing old record(onlyone i.e maintaing thepartial duplicate date )and add new record

  12. What are the Major differences between appcore.pll and appcore2.pll

  13. Advertisement

  14. How do we see the data in Cluster table?

  15. What is relational database ? Give me an example !

  16. What is cursor and where do you use them?

  17. ORA-26027: unique index string.string partition stringinitially in unusable state

  18. Define the difference between cycle counting and physical inventory?

  19. How to create zoneusers

  20. Name at least five reports in oracle inventory related totransaction ?

  21. How to call a stored procedure inside a trigger? Give an example.

  22. The Task is that to register a Form into Oracle Apps on a particular responsiblity.- First i moved the FMX & FMB file into the custom_top through FTP- Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly..- When i get into the particular responsiblity i can see the Form name getting listed.But when i click that to open..... i cant able to see the form.I need any one your help in advicing me...what would be the problem.

  23. What is work order less Transaction in WIP?

  24. In which tables the transaction details stored? at least two.

  25. I am importing large data from oracle to work library.in log there is a error message worklibrary space is not enough.then how to import the data safely to sas environment.

  26. Advertisement

  27. What is the purpose of catlaog in oracle rman?

  28. Is UOM maintained at master level or organization level or both?

  29. How will call a Key Flexfield Routine in Oracle Apps Forms and what are the arguments to be passed to that routines ?(He was asking me the Package name and Procedure)

  30. What are the pros and cons of auto extend of table spaces?

  31. What is ora-00252 and ora-00272 error represents how can uprevent this error?how can u trouble shhot this error?

  32. Which one Module is Biggest Module in oracle apps?

Advertisement
Advertisement