Oracle Technical Interview Questions

Oracle Technical Interview Questions

OAF

S.No	Question
1	How do you rate yourself in OAF? ( 1 to 10 )
2	What is MVC, Explain onion form?
3	What are the methods in controller?
4	What is extension, what is the difference between extension and customization?
5	What are the levels of personalization?
6	What is BC4J and what are the components of BC4j?
7	What is the difference between inline Lov and External Lov?
8	What is the difference between JavaBean and Query Bean?
9	Can we extend every possible application module?
10	Explain the AM and VO Extension steps?
11	What is EO and AO and which package should include EO and AO?
12	What is MDS and explain tables which stores MDS?
13	What are the tools used for decompiling java class?
14	What will setmaxfetchsize(0) will do?
15	Have you ever developed page which shows hierarchical data. Which component /region is used for drill down functionality. And can we enable search on hierarchical page?
16	Which api is used to print the document / page in toad?
17	What is switcher and when it is used?
18	What is SPEL?
19	What is PPR? And how we can use it and what is the benefits of using PPR?
20	What is passivation?
21	Can we open oracle reports from OAF Page what are the different techniques?
22	Can we call java class in oaf controller?
23	How to use db sequence what are the different levels?
24	What are the different levels of validations, please explain?
25	How to use key flex field in oaf? Please explain?
26	Is it possible to select different combination and save this combination in one field? If it is possible please explain the steps?
27	How to enable attachments in OAF and which VO is attached to it?
28	Can we extend / customized standard attachment VO?
29	Can we use customized category in attachment and how to make it readonly so user cannot be able to change it?
30	If we do not use the standard functionality of attachment what is the other way to attach the documents?
31	Have you ever developed Excel upload pages in oaf?
32	Is it possible to open parameterized OAF page from D2k? if yes please explain?
33	Which javabean is attached to attachment image , messageTextInput and lov?
34	Have you ever call webservice in oaf page?
35	What are different ways to send parameters in oaf and can it is possible we send these parameters as hidden parameter?
36	What is row reference and how we get the row reference, Can we get the row reference from seeded pages?
37	Is it possible we can send the same page as notification for approval?
38	What is the difference between page and region, can we run the region in Jdeveloper?
39	How we can make the page read only and editable?
40	Have you integrated AME with OAF?
41	Can we open the page from notification on Edit mode?
42	Is it possible to save information from notification in database table?
43	Explain the steps to integrate OAF region as notification in workflow builder?

Java

S.No	Question
1	How do you rate yourself in Java? ( 1 to 10 )
2	How to create Java concurrent programs and how it is registered ?
3	What is polymorphism , abstraction and encapsulation?
4	What is tree map in Java? And what is the purpose to use tree map?
5	What is the difference between Method overriding and method over loading?
6	What is the difference between abstract and interface?
7	What is meant by final keyword in java?
8	What is the difference between class and object?
9	Which methods are used for read and write data in java?
10	What is enumeration?

Web services

S.No	Question
1	How do you rate yourself in Webservices? ( 1 to 10 )
2	Have you ever worked on custom webservices? If yes which tool you have used?
3	How to create the webservice and how you can access it? What is the advantage to use webservice?
4	What are the different http methods in webservices?
5	Which method you have used to encode the authorization?
6	What is the difference between SOAP and REST webservice?
7	JAX-WS stands for?
8	REST stands for (Representational state transfer)?
9	SOAP stands for (Simple Object Access Protocol)?
10	What are different ways to test webservices?

Integrated SOA Gateway Web Services

S.No	Question
1	How do you rate yourself in integrated SOA gateway? ( 1 to 10 )
2	How you ever used webservices for integration different systems?
3	What are the steps to enable standard webservice?
4	What is Json message?
5	What are the levels to create json message for standard webservices? And how you will access it?
6	Is it possible to create custom webservice and register it in SOA Gateway? If yes please explain the steps?

Integrations

S.No	Question
1	How do you rate yourself in Integrations? ( 1 to 10 )
2	Explain your integration experience?
3	Which methods you adopt for integrations and how much the complexity involved in integrations.

Reports

S.No	Question
1	How do you rate yourself in Reports? ( 1 to 10 )
2	What are anchors in reports?
3	What are different types of report triggers and also define order of firing?
4	What are different page layout sections?
5	What is placeholder column?
6	What is the difference between bind and lexical parameter? Please explain with examples
7	What is user exits?
8	What is report bursting ? what is the benefit of using report bursting please explain the steps and give any suitable example?
9	How many groups are used in matrix report?
10	What are the ways to monitor the performance of the report?
11	What are the different ways  to create reports?
12	Is it mandatory to create data model for oracle reports? If No please explain what is the other methods to create oracle reports?
13	What is the field limits in rtf?
14	Have you ever worked on excel templates ? if yes, please explain the steps?

Forms

S.No	Question
1	How do you rate yourself in Oracle Applet Forms ( 1 to 10 )
2	What is the difference between call form , new form and open form?
3	What is the form and compiled form extension
4	How to show and hide columns in oracle forms?
5	How to change the colour of the row on specific condition?
6	Have you ever customized standard forms ? if yes, what are the steps?
7	What is the sequence of firing triggers in forms?
8	What is the difference between lov and list item?
9	Explain can you covert or reverse engineer fmx back to fmb? (it is not possible)
10	Is it possible to execute dynamic sql from forms (yes it is possible through forms_ddl or dbns_sql database package from forms)

Workflow

S.No	Question
1	How do you rate yourself in oracle workflow? ( 1 to 10 )
2	What is the primary purpose of a workflow?
3	What job does the setItemUserkey API perform?
4	Which work engine api should you use to begin execution of an activity?
5	What is the difference between create process and start process?
6	Which two mandatory parameters required for start workflow process?
7	How many custom workflows you have created?
8	What is the difference between getItemAttributeText and setItemAttributeText?
9	How to use function or procedure in workflow?
10	Have you ever modified the standard seeded workflow? Please explain the steps in detail?
11	Have you worked on AME?
12	Have you created any custom transaction type?
13	What are the components of AME? How to create parallel and position based approvals?

WEBADI

S.No	Question
1	How do you rate yourself in PLSQL / SQL? ( 1 to 10)
2	Have you worked on Web ADIs?
3	Explain the process to create Web ADIs

SQL

S.No	Question
1	How do you rate yourself in PLSQL / SQL? ( 1 to 10)
2	What is the purpose of Global temporary table?
3	What is the difference between truncate and delete?
4	Which command is used to limit the records in query?
5	What is the difference between DDL and DML ?
6	What is the difference between where and having clause?
7	What is the difference between RANK and DUNS_RANK function?
8	What is the difference between local temp tables and global temp tables?
9	What are the wild card operators?
10	What is the difference between view and materialized view and how we will create the materialized view?
11	What is pivot clause? Have you ever used pivot clause in your query? What is the purpose to use pivot clause?
12	What is the difference between function and procedure?
13	Which function is used to replace the spaces?
14	What is the difference between Least and floor?
15	What is purpose to use rank over partition function  in query?
16	Please Explain P2P and O2C cycle?
17	What are the important tables in P2P?
18	What are the important tables in O2C?
19	What is the difference between interfaces and APIs?
20	Please tell us important APIs ?
21	What is user hooks? What are the steps to create user hooks?
22	Explain sub ledger accounting tables and their purpose?