Just Crack Interview

Oracle interview questions – page 3

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

Advertisement

  1. What are indexes ? What are the advantages ? (Phone Screen)

  2. What are the error tables in OM

  3. What is WITH CHECK OPTION

  4. In a Standard form a DFF is disable?How we can Enable it?

  5. What are the differences you find when working with oracle91 and sql server 2005?

  6. Mention the interface tables for item open interface andopen transaction interface and also their respectiveproduction tables.

  7. Which is the table for storing organization information?

  8. How can reply if interviewer say thats why you choose B.Tech after passing the exam of Bsc.

  9. ORA-01508: cannot create database; error in file 'string' atline string

  10. I have 2 Databases. How can create a table in particulardatabase? How can i know the list of tables presented eachdatabase?( in oracle 10g)

  11. What are important reports in HRMS,GL,AP,AR in oracle apps?

  12. Can Constraints cannot be exported through EXPORT command ?

  13. Advertisement

  14. What is the difference between oracle 81,91,11i

  15. How many null values can be inserted in a coulmn whihc is unique constraint

  16. How to register a form and stored procedure in oracle apps

  17. What are stock locators and how to define them? name thetables where the stock locator information is stored. atleast two.

  18. Which is better Oracle or MS SQL? Why?

  19. I have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

  20. Can we use toad, winaql in oracle database to access sqlqueries.

  21. How does accounting occured in Expense Reporting?

  22. What is the use of Printer Definition file (PRT) in Reports ?

  23. How many types of profile option is there in oracle hrms.why it is necessary?

  24. What is the difference between character mode,bitmap mode

  25. In support project one ticket alloted which steps follows manualy tell me ?

  26. Advertisement

  27. How to attach the multiple templates in XML Pub Report?

  28. Overloading of stored procedure is possible in oracle?

  29. What is configuration your file structure

  30. What is integrity constraints?

  31. How to get the on hand quantity of an item across allorganizations? name the underlying tables.

  32. Can we execute one concurrent program through anotherconcurrent program?

Advertisement
Advertisement