1)Difference between truncate , delete and drop?
2)Types of cursors?
Implicit cursors
Explicit cursors
3)what is user defined and pre defined exceptions?
4)difference between view and materialized view?
5)what are the cursor attributes?
%NOTFOUND
%FOUND
%ROWCOUNT
%ISOPEN
6)explain few predefined exceptions in Oracle?
TOO_MANY_ROWS
NO_DATA_FOUND
INVALID_CURSOR
ZERO_DIVIDE
7)what is the purpose of bulk collect?
8)explain difference between case and decode function in Oracle
9) explain group by and having in Oracle ?
10)difference between union and union all?
11)What are aggregate functions and character functions in Oracle ?
12) what is the purpose of explain plan in sql developer?
Explain plan is used during performance tuning of sql Query. Explain plan explain the cost of the query, any full table scan.
13)explain different constraints in Oracle ?
NOT NULL
UNIQUE
PRIMARY KEY
FORIEGN KEY
CHECK
14)what is the difference between fast refresh and complete refresh in materialized views
15)how to refresh a materialized view in Oracle.
16) what is the purpose of trigger and different types of triggers in Oracle?
17)what is mutating error ?
18)what is pragma autonomous transaction ?
19)Difference between pre Query and post Query in Oracle Forms?
20)Difference between form personalisation and custom pll?
21)Difference between request group and request set in Oracle apps?
22)Have you worked on developing concurrent program? Explain complete process?
24)How to generate trace file for concurrent program?
25)how to call concurrent program from plsql block?
26)what are mandatory parameters for package which called from concurrent program?
27)Explain xml bursting concept in Oracle apps?
28)what is the purpose of utl_file?
29)what is the link between concurrent program and xml publisher template and data definition?
30)which will be fired first whether form personalisation or custom pll?
First form personalisation will be fired.
31)explain KFF and DFF in Oracle apps ?
32)Explain different triggers in Oracle RDF Reports?
33)How to display messages in rdf reports?
SRW.MESSAGE()
34)What are the profile options we need to check to enable Oaf personalisation?
35)What is difference between form or function level in form personalisation?
36)what are different types of valuesets in Oracle apps?
37)what are the tables which store data definition and data templates information in Oracle apps?
2)Types of cursors?
Implicit cursors
Explicit cursors
3)what is user defined and pre defined exceptions?
4)difference between view and materialized view?
5)what are the cursor attributes?
%NOTFOUND
%FOUND
%ROWCOUNT
%ISOPEN
6)explain few predefined exceptions in Oracle?
TOO_MANY_ROWS
NO_DATA_FOUND
INVALID_CURSOR
ZERO_DIVIDE
7)what is the purpose of bulk collect?
8)explain difference between case and decode function in Oracle
9) explain group by and having in Oracle ?
10)difference between union and union all?
11)What are aggregate functions and character functions in Oracle ?
12) what is the purpose of explain plan in sql developer?
Explain plan is used during performance tuning of sql Query. Explain plan explain the cost of the query, any full table scan.
13)explain different constraints in Oracle ?
NOT NULL
UNIQUE
PRIMARY KEY
FORIEGN KEY
CHECK
14)what is the difference between fast refresh and complete refresh in materialized views
15)how to refresh a materialized view in Oracle.
16) what is the purpose of trigger and different types of triggers in Oracle?
17)what is mutating error ?
18)what is pragma autonomous transaction ?
19)Difference between pre Query and post Query in Oracle Forms?
20)Difference between form personalisation and custom pll?
21)Difference between request group and request set in Oracle apps?
22)Have you worked on developing concurrent program? Explain complete process?
24)How to generate trace file for concurrent program?
25)how to call concurrent program from plsql block?
26)what are mandatory parameters for package which called from concurrent program?
27)Explain xml bursting concept in Oracle apps?
28)what is the purpose of utl_file?
29)what is the link between concurrent program and xml publisher template and data definition?
30)which will be fired first whether form personalisation or custom pll?
First form personalisation will be fired.
31)explain KFF and DFF in Oracle apps ?
32)Explain different triggers in Oracle RDF Reports?
33)How to display messages in rdf reports?
SRW.MESSAGE()
34)What are the profile options we need to check to enable Oaf personalisation?
35)What is difference between form or function level in form personalisation?
36)what are different types of valuesets in Oracle apps?
37)what are the tables which store data definition and data templates information in Oracle apps?