Interview Questions Oracle Apps

PLSql
——————————————————————————————————————–
1) Difference between functions and procedures?
2) What is Cursor?
3) What are the types of cursor?
4) What are the attributes of cursor?
5) What is reference cursor?Explain with application?
6) What is Exceptions?What are the types?
7) How can you raise exception?
8) Examples of Predefined exception?
9) What is raise_application_error?
10) What are SQLCODE and SQLERRM functions?
11) Explain Global Temporary Table with the application?
12) What are the types of GTT?
13) What is Pragma Autonomous Transaction?
14) What is bulk collector?
15? Can we limit the number of rows in bulk collector?
16) Difference between for and for all?
17) What is the benefit of using record group?
18) Difference between decode and case?
19) Explain
(i) substring
(ii) instring
(iii) NVL
(iv) NVL2
20) Difference between Union and Union all?
21) Can we declare Cursor as private?
22) Different types of data type?
23) Difference between truncate and delete?
24) What are rollback and savepoint?
25) What are analytic functions?
26) Query to delete duplicate rows?
27) Query to find the second maximum number?
28) Difference between rank and dense rank?
29) BEGIN

SELECT count(1) into v_count FROM test ;

END;
What are the exceptions that the above code can throw?
30) insert into test (rollno) values (1);
create table test1(name VARCHAR(2));
delete from test3;

What will be the result if the session ends up?
31) What is an index?
32) How can we remove indexing?
33) If one column has null values in it and we are applying ORDER BY ASC clause, what will be the sequence of the result?
34) Difference between view and materialized view?
35) Will the package throw any compilation error, if we have a function in package body and not declared in package specification?(and vice versa)

**********************************************************************************************************************************************************
**********************************************************************************************************************************************************
Oracle APPS
———————————————————————————————————————————————————-
1) Difference between 11i and R12?
2) What is lookup?
3) What is value set?
4) Difference between value set and lookup?
5) Different types of value set with examples?
6) How can we make table value sets dependent?
7) Can we direct make dependent type value set?
8) How can we get distinct values in table type value set?
9) In table type value set, can we write query in table name?
10) If suppose in List of values want to display more than three columns, what will be the approach?
11) Suppose we have two parameters, org id (not mandatory) and sales order.
If the user enters the value in Org id then the value of sales order should be filtered out on the basis of org id parameter and if in case the user doesn’t
enter any value in org id parameter then the all the sales order should appear in the LOV.What will be the approach to achieve the above scenario?
12) What is KFF and DFF?
13) Difference between request set and request group?
14) Different types of executables?
15) Define Profile options?
16) Different types of Profile options?
17) What is the navigation for creating user defined profile options?
18) Profile options can be set at different levels.Which level has the highest precedence?
19) What is multi org access control(MOAC)?
20) What is multi org structure?
21) What are the phase code and status code of concurrent program?
22) If we are using plsql procedure executable, what are the two mandatory parameters that should be passed to the package?
23) How can we call concurrent program throgh backend?
24) How can we register concurrent program?
25) What is menu and functions?
26) What are the values for retcode?
**************************************************************************************************************************************************************
**************************************************************************************************************************************************************
BI Reports
————————————————————————————————————————————————————–
1) What will be the steps for developing a report from scratch?
2) What are the different types of triggers used in reports?
3) Expalin the XML structure?
4) If we want to pass parameters in Before or After report trigger, what are the mandatory steps?
5) What is bursting?
6) How can we do calculations in XML?
7) How can we split the page?
8) How can we dynamically display logos in report?
9) How can we generate multilingual reports?
10) How can we sort data in reports?
11) Can one Data definition code be attached to multiple template?
12) What is the executable used for XML?
13) Latest BI report component
**************************************************************************************************************************************************************
**************************************************************************************************************************************************************
Interfaces and Conversions
————————————————————————————————————————————————————–
1) Difference between interface and conversion?
2) Intefaces and conversion examples
3) What are the steps involved in interface?
4) What are the validations performed?
5) What are the codes of process flag?
6) Standard concurrent program used?
7) What will be the process if the validations failed or concurrent program errored out?
8) How can we increase the performance in the conversion process?
9) If Sql loader is used
1) What are the types of files with extensions?
2) What is .ctl file?
3) Can we skip the records from the flat file while loading?
4) What are the modes of SQL loader?
5) Can functions be used in SQL Loader?
6) If you want to load data into multiple tables, how can you do that?
7) How can we set default values in SQL Loader?

**************************************************************************************************************************************************************
**************************************************************************************************************************************************************
General Questions
————————————————————————————————————————————————————–
1) O2C cycle with tables and concurrent programs
2) P2P cycle with tables
3) Types of purchase order
4) Recent Form Personalization component(if worked)
5) Different types of triggers in Form Personalization?
6) Difference between extension and customization?
7) What is API?Why it is used?
8) Names of API used.
9) Process of developing a form from scratch?
10) Why template.fmb is taken while developing a form?
11) Triggers in Form
12) How can we disable item in form?
13) Steps to extract explain plan
14) steps to tune the code
15) What is the model used in your current project?

Leave a reply:

Your email address will not be published.

Sliding Sidebar