If you're looking for Oracle SOA Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research Oracle SOA has a market share of about 32.2%. So, You still have opportunity to move ahead in your career in Oracle SOA Analytics. Mindmajix offers Advanced Oracle SOA Interview Questions 2018 that helps you in cracking your interview & acquire dream career as Oracle SOA Analyst.
Q. What is SOA?
Service Oriented Architecture (SOA) is used to develop Enterprise applications by using a collection of services which communicates each other. Service-Oriented Architecture (SOA) is a set of principles and methodologies for designing and developing software in the form of interoperable services.
Q. Principles of SOA?
1. Loose coupling
Q. What is the difference between 10g and 11g?
SCA architecture was followed in 11g and not in 10g
In 11g you can put all your project SOA components in composite.xml file and deploy as a single deployment unit to single server, where in 10g you have to deploy each component to the respective server (i.e. ESB to ESB server, BPEL to BPEL Server)
Basically all the SOA components like BPEL, ESB (Called Mediator in 11g), & OWSM are brought into one place in 11g using SCA composite concept.
The major difference between 10g & 11g would be the app server container. 10g by default runs onOC4J while 11g runs on Web logic Server.
In 10g every BPEL is a separate project, but in 11g several components can make 1 project as SCA.
In 10g consoles are separate for BPEL and ESB, but in 11g Enterprise Manager contains all.
In 10g BAM and business rules are outside SOA Suite, but in 11g they are in SOA Suite.
Q. Is Oracle SOA same as Oracle Fusion Middleware?
No because SOA is one of the parts in Fusion middleware and SOA behaves like user interface where as Fusion is big platform
Q. What is SCA?
Service Component Architecture (SCA) provides a programming model for building applications and systems based on a Service Oriented Architecture. SCA is a model that aims to encompass a wide range of technologies for service components and for the access methods which are used to connect them.
Q. What is the SOA Suite 11g Components?
1. Oracle Adapters
2. Oracle Mediator
3. Business Events and Events Delivery Network
4. Oracle Business Rules
5. Human Workflow
6. Oracle Business Activity Monitoring
7. Oracle Enterprise Manager
Q. What is choreography? How does it differ from orchestration?
In choreography there is no business process to control the integration between the systems; each system will directly integrate with one another in sequence where as in Orchestration there is a business process which controls all the services (source/Target) which is part of the integration.
Q. What are the different design patterns in SOA?
2. Asynchronous Fire and Forget
3. Asynchronous Delayed Response.
Q. In how many ways can a process be deployed?
1. Using Jdeveloper
2. Through Enterprise Manger Console
3. Through Weblogic Scripts.
Q. What are dspMaxThread and recieverThread properties? Why are they important?
Receiver Threads property specifies the maximum number of MDBs that process Async across all domains. Whereas the dspMaxThread are the maximum number of MDBs that process Async and threads that operate across a domain. So, we need to ensure that the dspMaxThread value is not greater than Receiver Threads.
Q. How does a Async request run in the backend?
The sequences of events involved in the delivery of invoke messages is as follows:
The client posts the message to the delivery service.
The delivery service saves the invocation message to the dlv_message table. The initial state of the message is 0 (undelivered).
The delivery service schedules a dispatcher message to process the invocation message asynchronously.
The dispatcher message is delivered to the dispatcher through the afterCompletion() call. Therefore, the message is not delivered if the JTA transaction fails.
The dispatcher sends the JMS message to the queue. Places a very short JMS message in the in-memory queue (jms/collaxa/BPELWorkerQueue) in OC4J JMS. The small JMS message triggers the Worker Bean in the downstream step.
This message is then picked up by a Worker Bean MDB, which requests the dispatcher for work to execute. If the number of Worker Bean MDBs currently processing activities for the domain is sufficient, the dispatcher module may decide not to request another MDB.
MDB fetches the invocation message from the dispatcher.
MDB passes the invocation message to Oracle BPEL Server, which updates the invocation message state to 1 (delivered), creates the instance, and executes the activities in the flow until a breakpoint activity is reached.
Q. How to increase the transaction timeouts in SOA?
For the transaction timeout needs to be increased, all the below settings timeout value needs to be changed to the expected Timeout value.
2. Engine Bean
3. Delivery Bean
Q. Is it possible to use MS SQL Server as dehydration store with SOA Suite ?if yes how?
Yes it is possible.
To automatically maintain long-running asynchronous processes and their current state information in a database while they wait for asynchronous callbacks, you use a database as a dehydration store. Storing the process in a database preserves the process and prevents any loss of state or reliability if a system shuts down or a network problem occurs. This feature increases both BPEL process reliability and scalability. You can also use it to support clustering and failover.
Q. What is SOA governance? What are its functions?
Service-Oriented Architecture (SOA) governance is a concept used for activities related to exercising control over services in an SOA Some key activities that are often mentioned as being part of SOA governance are:
Managing the portfolio of services: This includes planning development of new services and updating current services.
Managing the service lifecycle: This is meant to ensure that updates of services do not disturb current services to the consumers. Using policies to restrict behavior: Consistency of services can be ensured by having the rules applied to all the created services. Monitoring performance of services: The consequences of service downtime or underperformance can be severe because of service composition. Therefore action can be taken instantly when a problem occurs by monitoring service performance and availability.
Q. What is end point virtualization?
Generally a service bus is used for endpoint virtualization and in 11g stack; Oracle Service Bus (OSB) is the primary service bus. In exposed proxy’s message flow, it can route the request to any of your environment’s actual (physical) service on the basis of whatever logic.
Mediator can also be used to expose the service and in mediator routing rule, it can be routed to actual service.
Q. What are DVM’s and how are they helpful in SOA?
DVM-Domain Value Map is static mappings between a source and target system which can be used in transformations. The value can be changed via SOA composer.
Q. What is the difference between XREF and DVM?
XREF- It is dynamic since the values to the XREF can be populated dynamically and it is stored in XREF_DATA table in SOA Dehydration store.
DVM- Domain Value Map is static mappings between a source and target system which can be used in transformations.
Q. What is Dehydration store?
Dehydration store is the database where the instances get stored when it gets dehydrated by the process on the occurrence of non-idempotent activities and also stores the information on the long running processes.
Q. What is Decision service?
Oracle SOA Suite provides support for Decision components that support Oracle Business Rules. A Decision component is a mechanism for publishing rules and rule sets as a reusable service that can be invoked from multiple business processes. These rules can be changed without redeploying the code.
Q. Why we use BPEL and OSB?
OSB is the light-weight service bus wherever there is not much business logic involves and there is need to just get the message routed between the systems OSB is used where as when there is more business logic involves in the process, then BPEL will be used.
Q. What is MDS?
MDS –Metadata Store
Wsdl and Schemas to be used in the process can be published to the MDS and get it used in the code by referring the artifacts from the MDS
1. JAR (Deployment unit) size will be reduced.
2. Duplication of the artifacts can be avoided between the services.
Q. What is a XA data source? How it differs from a non-XA data source?
An XA transaction involves a coordinating transaction manager, with one or more databases (or other resources, like JMS) all involved in a single global transaction. Non-XA transactions have no transaction coordinator, and a single resource is doing all its transaction work itself (this is sometimes called local transactions).
Q. How can we secure our web services using Oracle SOA Suite?
When accessing the services should be restricted to the group,then service should be secured via WSM (Web service Manager).
Q. How to deploy an XSL file without deployment of BPEL Process?
We will directly deploy the XSLT, options: –
1. Using ANT script by file replacement in TMP folder.
2. By creating a folder in BPEL PM Installation folder and specifying its location in our BPEL code with http call and replacing our xslt to that location.
Q. What is HA File and FTP Adapters?
In the clustered environment, File and FTP adapters should be used as HA (High-Availability)
Inbound: It is controlled by Control Files and avoids the race between the manages servers in reading the files where the reference of the files read by the managed servers will be maintained in the control directory.
Outbound: It is controlled by DB Mutex table exist in the SOA dehydration store and this avoids duplicated been written to the same file when all the managed servers in the clusters process the same messages.
Q. What is singleton Property in SOA?
In the clustered environment when the processing of the message should happen via only one SOA managed server, then the property singleton needs to be defined at the adapter level.
Q. What is a pick activity? Can I have a pick activity with no onMessage branch?
Pick activity picks the messages from service (Source) which has multiple operations or the BPEL process needs to receive the messages from multiple source system. Pick activity should have at least on Message branch.
Q. What is a flow activity? What is a flowN activity and how does it leverages the flow activity?
Flow activity is used, when parallel execution of the flow is needed and to use this property “non blocking invoke should be set as true “at the partner link level and no. of execution of parallel flow is defined and static. Where as in Flown the no. of execution of parallel flow is not static and it is determined during run time.
Q. What do you mean by non-idempotent activity? Which all activities are non-idempotent by default?
Activities like Pick, Wait, receive, reply and checkpoint() are called non-Idempotent activity and during the execution of the process whenever these activities are encountered then it gets dehydrated to the dehydration store.
Q. How can we embed or use a java code in BPEL?
Using JAVA embedding activity in BPEL, Java code can be embedded in BPEL and can be used.
Q. How does pick activity differ from a receive activity?
Pick activity can act as a multiple receive activity in some business scenarios. If we have two inbound operations and both can trigger the bpel process then we will go with pick activity as we can’t have two receive activity with create Instance box checked.
Q. How can we make a partner link dynamic?
If we have to send the request to different service which has the same wsdl then dynamic partner link will be used and using addressing schema we can set the endpoint dynamic to send the request to the desired service.
Q. What is a nonBlockingAll property?
Non- blocking invoke is used when Parallel flow needs to be executed where new thread will be created for each invoke a activity and which will execute simultaneously.
Q. What is getPreference property? How do we set it and what advantage it provides?
Hard coding is not a good practice, so to avoid hard coding preference variable can be used and the value of the preference variable is accessed using getPreference().The preference variable value can be changed without re-deploying the code via em console MBean property.
Q. How can we improve the performance of an XSL file?
By avoiding use of various if statements and using choose and by using for-each group in place of for-each.
Q. How do we handle transactions in BPEL?
Property needs to be defined to start the new transaction or to continue with the same transactions
Property Name: Transaction and if this has value as required then the BPEL process will be continued in the same transaction where as if the value is defined as requiresnew then it will start the new transaction.
Q. What are transient and durable BPEL processes?
Durable:-It is long running process and initiated through a one-way invocation and do incur one or more dehydration points in the database during execution Ex: Asynchronous
Transient:-It is short-lived process, request-response style processes and do not incur dehydration during their process execution Ex: Synchronous.
Q. When u will go for Sync process?
Whenever the services returns the response in few seconds, it is recommended to go for synchronous BPEL process if not the BPEL process should be Asynchronous the reason is calling application can’t proceed further in case of synchronous process.
Q. What is a syncFileRead operation? Is a inbound or a outbound operation? Can my process begin with syncFileRead operation?
When file has to be read in the mid of the BPEL process, then we will use syncFileRead Operation, means some process should initiate the file read process and it is an outbound operation and process can’t begin with Sync File read.
Q. Can we use a File Adapter to get a file without reading its content?
Yes, by selecting the Do not read file content check box in the Jdeveloper wizard while configuring the “Read operation.”
Q. How to increase performance increase in bpel (Db Adapter/file adapter)?
We can increase the performance by writing indexes and sequences.
(Or) Go to application server —-> Configurations —–> Change Xml file
Q. Explain error handling in BPEL and what is a error handling framework? How does a error handling framework better than simple error handling in BPEL?
EHF –Whenever any error thrown by the BPEL process/Mediator then EHF will check whether exist in Fault-Bindings.xml files and if so then the action in the Fault-Policy.xml file will be taken and if the action is not found then the fault will the thrown and it will be handled in the catch block.
Q. How do we resubmit a faulted process?
Scenario A: The BPEL code uses a fault-policy and a fault is handled using the “ora-human-intervention” activity, then the fault is marked as Recoverable and the instance state is set to “Running”.
Scenario B: The BPEL code uses a fault-policy and a fault is caught and re-thrown using the “ora-rethrow-fault” action, then the fault is marked as Recoverable and the instance state is set to “Faulted”; provided the fault is a recoverable one (like URL was not available).
Q. Predefined errors in BPEL?
1. Custom errors
2. Timed out errors
3. BPM errors
4. Validation Errors
Q. What is a throw activity? What it is?
Throw activity will explicitly throw the fault and this fault will get caught by the catch block and the corresponding actions will get executed.
Q. What is Web service?
Web services are application components, which are self-contained and self-describing and provide services based on the open protocol communication (i.e. SOAP UI, HTTP over the net).
Q. Difference between URI and URL?
A URI is an identifier for some resource, but a URL gives you specific information as to obtain that resource. A URI is a URL and as one commenter pointed out, it is now considered incorrect to use URL when describing applications. Generally, if the URL describes both the location and name of a resource, the term to use is URI. Since this is generally the case most of us encounter every day, URI is the correct term.
Q. What is Mediator?
The Mediator is in charge of interconnecting, within an SOA composite application, components that expose different interfaces. In addition, the Mediator can perform duties such as filtering and making routing decisions.
The composite editor in Jdeveloper gives you the flexibility to define the interface now, to choose an existing interface, or to define the interface later as you wire components to the Mediator.
Transforming data from one representation to another is, along with routing, one of the key functions of the Mediator.
Q. Difference between ESB and Mediator?
In 10g for routing, separate router need to keep along with ESB for routing and filter expressions.
Where as in 11g mediator contains routing rules and filter expressions itself.
Q. What is the difference between concrete and abstract wsdl?
Concrete: Besides the information about how to communicate to the web service, it the information on where the service exist. It has Bindings (Protocol the message should be sent) and Services(has endpoint for each bindings) .
Abstract: It has information about how to communicate to the web service like types (Schema), Message (input and output messages service accepts) ,Operations (operation that can be performed on this service) and port Type.
Q. In SOA do we need to build systems from scratch?
No. If you need to integrate or make an existing system as a business service, you just need to create loosely coupled wrappers which will wrap your custom systems and expose the systems functionality in a generic fashion to the external world.
Q. Can you explain business layers and plumbing layers in SOA?
In SOA we can divide any architecture in two layers. The first which has direct relevance to the business as it carries out business functions. The second layer is a technical layer which talks about managing computer resources like database, web server, etc. This division is needed to identify a service. Consider the figure ‘Simple order system’. It has various components which interact with each other to complete the order system functionality.
Figure: Simple order system
The simple order system can be divided in to two layers (see figure ‘business and plumbing layer’ – one which is business related and second which is more technical related). You can see the plumbing layer consisting of data access layer, AJAX, and yes more technical stuff.
Figure: Business layer and plumbing layer
Q. What’s the difference between services and components?
Services are logical grouping of components to achieve a business functionality. Components are implementation approaches to make a service. The components can be in Java, C#, C++ but the services will be exposed in a general format like Web Services.
Q. Can you describe the complete architecture of SOA?
Figure ‘Architecture of SOA’ shows a complete view of an SOA. Please note this architecture diagram is not tied up with implementations of Microsoft, IBM etc. It’s a general architecture. Any vendor who implements SOA needs to fulfill the below SOA components. How they do it is completely their own technological implementation.
Figure: Architecture of SOA
The main goal of SOA is to connect disparate systems. In order that these disparate systems work they should message each other. ESB (Enterprise Service Bus) acts like a reliable post office which guarantees the delivery of messages between systems in a loosely coupled manner. ESB is a special layer which delivers messages between applications. In the figure we have shown a huge plump pipe. It’s not hardware or some wire etc. It’s a group of components/software which helps you send and receive messages between the disparate applications. Do not try to code your own ESB, you can think of buying one from Microsoft, IBM, Oracle, Progress, etc.
1. SOA registry is like a reference database of services. It describes what each service does, where they are located, and how they can communicate. It’s a central reference of meta-data for services.
2. SOA workflow allows us to define a work flow using services in the SOA registry. We will read more about BPM in further questions.
3. Service broker reads the work flow and takes services from the SOA registry and ties them together. Service brokers are normally middleware like EAI (Enterprise application Integration) products. You can get a list of decent EAI from Sun, Microsoft, and IBM etc.
Process manager is nothing but a collection of SOA registry, SOA workflow, and service broker.
SOA supervisor is a traffic cop ensuring that services do not have issues. It deals mainly with performance issues of the system so that appropriate service levels are met. If any of the services have performance problems it sends messages to the proper infrastructure to fix the issue.
Note: The above explanation is of the general architecture for SOA. Any vendor (Microsoft, IBM, SUN, etc.) who gives a solution for SOA should have the above components in some or the other manner. As this is a software architecture book, we will not be covering specific vendor implementations. We would advise the reader to map this to their vendor products for a better understanding.
Q. What are ends, contract, address, and bindings?
These are the three terminologies on which SOA service stands. Every service must expose one or more ends by which the service can be made available to the client. The End consists of three important things: where, what, and how:
1. Contract(What): Contract is an agreement between two or more parties. It defines the protocol how clients should communicate with your service. Technically, it describes parameters and return values for a method.
2. Address(Where): An Address indicates where we can find this service. Address is a URL, which points to the location of the service.
3. Binding(How): Bindings determine how this end can be accessed. It determines how communication is done. For instance, you expose your service, which can be accessed using SOAP over HTTP or binary over TCP. So for each of these communication mediums, two bindings will be created.
Below figure show the three main components of the end. You can see the stock ticker is the service class, which has an end hosted on WWW.SOA.COM with HTTP and TCP binding support and using the Stock Ticker interface type..
Figure: Endpoint Architecture
Note: You can also remember the end point by ABC where A stands for Address, B for bindings, and C for Contract.
Q. Are web-services SOA?
SOA is a thinking, it’s an architectural concept, and web service is one of the technical approaches to complete it. Web services are the preferred standards to achieve SOA.
1. In SOA we need services to be loosely coupled. A web service communicates using the SOAP protocol which is XML based, which is very loosely coupled. It answers the what part of the service.
2. SOA services should be able to describe themselves. WSDL describes how we can access the service.
3. SOA services are located in a directory. UDDI describes where we can get the web service. This is nothing but the implementation of the SOA registry.
Get Updates on Tech posts, Interview & Certification questions and training schedules