ORACLE INTERVIEW QUESTIONS

SQL/PL-SQL

1)What are synonyms? Why we use synonmyms?

2)What is the difference between delete table and truncate table

3) What is the difference between where clause and having clause?

4) What are row operators (distinct, all)

5) What is the use of dynamic SQL statement prepare and execute?

6) What is the difference between a simple join and a outer join?

7) What is %type and %rowtype?

8) What is a difference between procedure and function?

9) What is the difference between implicit and explicit cursors?

10) Can you pass a parameter to a cursor? What is the mode of the parameter that can be passed?

11) What are bind variables?

12) What is decode function?

13) Give 4 predefined exceptions raised

13) What is PRAGMA EXCEPTION_INIT?

14) What is the difference between actual parameter and formal parameter?

15) What is exception handler?

16) What are the different type of triggers ( each row, each statement)?

17) How to define user defined exception?

18) How to implement user-defined exceptions?

19) Advantages of packages?

20) What is database trigger? What is the difference between a SQL/forms trigger and a database trigger?

21) What is the difference between Packages and stored procedures ?

22) What is the difference between a stored procedure and a database trigger?

23) What are types of loops?

24) What is record type?

25) What are different types of loop constraints in PL/SQL?

26) What are scalar type of datatypes?

27) What is implicit data conversion and explicit data conversion?

28) Which are the functions, which returns some argument even if null argument is passed ( decode, nvl, replace)

29) What are error reporting functions

30)w hat is packaged cursor?

31) What is a Ref Cursor?

32)What are the Types of exceptions?

33) What is PRAGMA EXCEPTION_INIT?

34) What is Dynamic SQL?

35) What is Bulk binding of Bulk collect?

36) What are Autonomous Transactions?

37) What is PRAGMA AUTONOMOUS_TRANSACTION?

38) What are Materialized Views and Snapshots?

39) What are the types of Materialized Views?

40)What are the types of VIEWS?

41What is SQL Trace?

42)What are the types of Joins?

D2K

1. What is NOCOPY?

2. What are the types of REPORT TYPES?

3. What is ANCHOR and Anchor Properties?

4. What is User Exits? Types of user exits?

5. Types of Triggers in Reports?

6. What is Formula Column?

7. What is Summary Column?

8. What is Place Holder Column?

9. What are System Parameter in Reports?

10. What is Data Link?

11. In which tables FlexFields are stored?

12. Advantages of stored functions and procedures?

13. Difference between a function and a procedure?

14. What is Parameterized Cursors?

15. What are Cursor Attributes?

16. What is the Difference b/w Bind Parameter and Lexical Parameter?

17. What are Autonomous Transactions?

18. 18.List of some API’S?

19. 19.How to call WHO columns into the form?

20. 20. How to call flex fields in the form?

21. How to register a table and columns through back end?

22. How to get username / user id in reports?

23. How to submit concurrent programs through OS?

24. How to call a form from another form?

25.what are the triggers that fire on item?

26.What are Transactional Triggers in Forms?

27. What is the difference between PRE_COMMIT and POST_COMMIT triggers?

28. What are Global variables in Reports?

*Global variables are the variables that ca n be assigned to parameters in reports and those parameters can be used in reports

create_parameter_list (------)

add_parameter (----:Global_var);

run_product(….);

Oracle Apps.

1.What is an Architecture of Oracle apps?

2.How do you find that multiorg is installed?

3.What are the steps to register a form in oracle apps?

4.What are the steps to register a report in oracle apps?

5.How many types of Executable Methods? What are they?

6.What is Token?

7.What is a Data Group?

8.What is Responsibility?

9. What are steps involved in developing a flex field?

10.What is the differences between conversion and Interfaces?

11.What is sql*loader? Why we use it?

12. How do u dump data from pl/sql block to flat files?

13. What r the validation types?

14.Can u tell form development process?

15.Tell some report names in PO,AP,GL?

16.Whis is flex-filed? Different Kinds of flex-fields?

17.What is AOL?