Oracle Interview Questions and Answers
Ques:- What are indexes ? What are the advantages ? (Phone Screen)
Ques:- What are the error tables in OM
Ques:- What is WITH CHECK OPTION
Ques:- In a Standard form a DFF is disable?How we can Enable it?
Ques:- What are the differences you find when working with oracle91 and sql server 2005?
Ques:- Mention the interface tables for item open interface andopen transaction interface and also their respectiveproduction tables.
Ques:- Which is the table for storing organization information?
Ques:- How can reply if interviewer say thats why you choose B.Tech after passing the exam of Bsc.
Ques:- ORA-01508: cannot create database; error in file 'string' atline string
Ques:- I have 2 Databases. How can create a table in particulardatabase? How can i know the list of tables presented eachdatabase?( in oracle 10g)
Ques:- What are important reports in HRMS,GL,AP,AR in oracle apps?
Ques:- Can Constraints cannot be exported through EXPORT command ?
Ques:- What is the difference between oracle 81,91,11i
Ques:- How many null values can be inserted in a coulmn whihc is unique constraint
Ques:- How to register a form and stored procedure in oracle apps
Ques:- What are stock locators and how to define them? name thetables where the stock locator information is stored. atleast two.
Ques:- Which is better Oracle or MS SQL? Why?
Ques:- I have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
Ques:- Can we use toad, winaql in oracle database to access sqlqueries.
Ques:- How does accounting occured in Expense Reporting?
Ques:- What is the use of Printer Definition file (PRT) in Reports ?
Ques:- How many types of profile option is there in oracle hrms.why it is necessary?
Ques:- What is the difference between character mode,bitmap mode
Ques:- In support project one ticket alloted which steps follows manualy tell me ?
Ques:- How to attach the multiple templates in XML Pub Report?
Ques:- Overloading of stored procedure is possible in oracle?
Ques:- What is configuration your file structure
Ques:- What is integrity constraints?
Ques:- How to get the on hand quantity of an item across allorganizations? name the underlying tables.
Ques:- Can we execute one concurrent program through anotherconcurrent program?