Top Oracle Apps Technical and Oracle SOA Interview Questions

Most Frequently asked Oracle Apps Technical and Oracle SOA Interview Questions:

With a rapid increase in the demand for candidates skilled in Oracle technology, I’ve prepared a set of interview questions along with their answers in this article.

Read our previous article on Oracle Forms and Reports Interview Questions.

This article covers:

  • Oracle Apps Technical Interview Questions
  • Oracle SOA Interview Questions 

Let's Explore!!

Oracle Interview Questions

Top Oracle Apps Technical and Oracle SOA Questions

Oracle SOA Interview Questions

Q #1) What do you understand by SOA and what are the benefits of using this architecture?

Ans: SOA stands for Service Oriented Architecture, which can be used to develop Enterprise Applications. Using this architecture, application components will interact with each other using interoperable services by following the communication protocol over the network.

Below are the benefits of using SOA:

  • Components stay loosely coupled and can be reconfigured.
  • Business services can be reused.
  • Data Security & Confidentiality.
  • Well defined Interfaces.
  • Better Flexibility and Maintenance.

Q #2) What is Oracle SOA Suite and what are its different components?

Ans: Oracle SOA Suite belongs to Oracle Fusion Middleware group of software products.

This tool is based on SOA architecture and helps in creating, managing & integrating services with the application components so as to deliver SOA composite application as one unit. This suite consists of five components.

  • Service Components further consists of:
    • BPEL Process
    • Oracle Mediator
    • Human Task Flow
    • Decision Services
  • Binding Components includes:
    • Services
    • References

Q #3 ) Can you explain the difference between architecture followed in 10g & 11g?

Ans: Given below are the differences between 10g and 11g:

  • In 11g, SCA architecture is followed but not in 10g.
  • In 11g, all of the SOA components (like BPEL, ESB etc.) are related to project can be deployed at once as a single unit using composite.xml file. In 10g, these components need to be deployed individually to the respective servers.
  • App server container for 11g is Web Logic Server while for 10g is OC4J.
  • In 11g, Enterprise Manager takes care of all SOA components while in 10g separate consoles are maintained for each component.

Q #4) What is the concept of SOA Governance?

Ans: SOA governance is introduced to administrate services in service-oriented architecture.

This governance is required to:

  • Create new services when required.
  • Update existing services.
  • Manage the lifecycle of services.
  • Enforce the rules on policies to maintain consistency.
  • Monitoring and tuning performance of services.
  • Manages user permissions on services.

Q #5) How can a process be deployed in SOA?

Ans: A process can be deployed using any of the below options:

  • JDeveloper
  • EMC(Enterprise Manager Console)
  • WebLogic Scripting.

Q #6) What is SCA and how is it useful?

Ans: Service Component Architecture (SCA) is a model for building applications and systems using SOA concepts. The composite service has the assembly of different components of the application and these components can be deployed together at once using SCA.

The various specifications of SCA are as shown below:

  • Assembly Model Specification.
  • Binding Specification.
  • Components Implementation Specification.
  • Policy Framework Specification.

Q #7) How can you achieve loose coupling in SOA framework?

Ans: Loose coupling can be achieved by abstracting and resolving the differences between different systems so as to provide seamless integration.

OSB facilitates the same and resolves the issues between service clients and business systems. SOA uses web services as building blocks to accomplish enterprise integration and component re-usage through loose coupling.

Q #8) Can you differentiate between mediator and OSB?

Ans: A mediator is part of a composite application and is used to mediate between the different components within and outside a composite application. While OSB i.e. Oracle Bus Service is a standalone ESB which mediates with heterogeneous clients and services without being a part of them.

A mediator can be deployed as SCA component while an OSB cannot.

For mediator, development can happen through JDeveloper IDE while for OSB, it can be done using Eclipse IDE or Web Console.

Q #9) Is SOA a part of Oracle Fusion Middleware?

Ans: Yes SOA is a part of Oracle Fusion middleware behaving as a UI within the big Fusion platform.

Q #10) How is choreography different from orchestration?

Ans: Choreography and orchestration, both are critical parts of the collaboration layer within service orientation i.e. SOA & BPM.

During choreography, systems get integrated without following any business processes. There is no process defined to control the integration and it is done as per the defined sequence of levels.

In Orchestration, a central process which can be a Web Service itself controls the other web services involved in the integration of systems. This central coordinator will coordinate the execution of various operations of web services involved in the operation and completes the integration.

Oracle Apps Technical Interview Questions

Q #11) Can you define an ERP System?

Ans: ERP stands for Enterprise Resource Planning. It is a business software system that allows an organization to automate and integrate with the various business processes sharing common data across enterprises.

ERP software typically integrates the different facets of an operation like product planning, development, and manufacturing, sales, marketing etc. using a single database, application, and interface.

Q #12) Explain Oracle Apps architecture.


Ans: Oracle Apps is a multi-tier architecture environment where the application server serves as an interface between clients and database servers.

Hence, the components of this architecture are:

  • Clients
  • Application Servers
  • Database Servers

Clients will initiate the request for an operation to be executed by the database. Application Server will act as an intermediate layer by sending the client request to the database and providing the requested data to the client.

Q #13) Can we create tables in APPS schema?

Ans: No, we cannot create tables in APPS schema and this schema will only have synonyms.

Q #14) What is a flexfield? List out its types.

Ans: Flexfield is a database field possessing inbuilt flexibility of defining reporting structure, which is relevant to specific organizations. A flexfield is made up of segments or subfields.

Given below are the two types of flex fields:

  • Key FlexFields: They are used to record key data elements.
  • Descriptive FlexFields: They are user-defined flexfields and can be customized.

Q #15) What are the different components you should consider while defining a responsibility in Oracle Apps?

Ans: A responsibility is a group of the below-mentioned components.

  • Menu (Mandatory): It is an arrangement of forms in a hierarchical manner.
  • Data Group (Mandatory): It defines the mapping between Oracle App products like forms, reports, concurrent programs, and Oracle database Ids.
  • Responsibilities and Request Security Groups (Mandatory): A request security group is the request group assigned to a responsibility.
  • Function and Menu Exclusions (Optional): Responsibility may or may not have an associated function and menu exclusion rules.

Q #16) What is a Value Set? List its various types.

Ans: As the name itself suggests, the value set is a predefined list of values used by Oracle for validation. It restricts the end user to enter junk data by providing an option to select a value from the predefined set of values.

There are totally eight types of value set validations that are supported by Oracle.

They are:

  • None (validated minimally)
  • Independent
  • Dependent
  • Table
  • Special (advanced)
  • Pair (advanced)
  • Translated Independent
  • Translatable Dependent

Q #17) How can we import the data into a database using SQL * Loader?

Ans: SQL * Loader is a utility that is used to import the data in bulk from external files.

Various features of this command line utility are as shown below:

  • They can perform selective loading.
  • They can perform multi-table loads.
  • Supports various format files.

This utility can be invoked using a set of commands.

SQLLDR CONTROL=Test.ctl, LOG=Test.log, BAD=Test.bad, DATA=Test.dat USERID=superuser/XXX, ERRORS=999, LOAD=3000, DISCARD=toss.dsc, DISCARDMAX=6

Q #18) What do you understand by Concurrent programs?

Ans: An executable file which can execute simultaneously with the other programs and utilize the hardware capacity to the fullest is called a concurrent program. Generally, these type of programs would be long-running and data-intensive.

They can be grouped with reports to form a request group.

Q #19) What does APPL_TOP directory contain?

Ans: APPL directory stores Oracle E-business Suite files and hence it is commonly known as APPL_TOP directory.

This directory contains the files along with the relative directories.

  • Technology Files
  • Product Files
  • Oracle E-Business Suite environment files

Q #20) What do you understand by a set of books?

Ans: Set of books is a financial reporting entity. It determines the functional currency, account structure, and calendar for a company or a group of companies.

There are two types of set of books.

  • Primary Set of Books: It consists of functional currency
  • Secondary Set of Books: It consists of reporting currency

Conclusion

With this, I am concluding this list of interview questions on “Oracle SOA” & “Oracle Apps Technical”.

You can bookmark this post for future reference and read it as and when required. I'm sure that these questions would really be of immense help to get through any oracle interview successfully.

Go to part 1 in the seriesTop Oracle Interview Questions

STH Team wishes you all success!!