Hi friends, I have taken various interviews for Junior and Senior consultant roles till now. So here I am sharing my experience regarding the same. I will be really helpful for you to crack the interviews and grab the opportunity which you are looking for. But always remember, look only for those opportunities which you are really fit for. Don't ever just mug up the concepts only for the sake of craking the interview because even if you crack the interview, it will not help you satisfy your on-job work in the short and long run both. So prepare hard and appear only for those jobs which really fit in your work profile..
Here are few interview questions in various topics of your need..
XML Basics:-
<elements>
<e>1</e>
<e attrib='a'>2</e>
<e>3</e>
<e>4</e>
<e>5</e>
</elements>
What is XPath?
XPath related tricky questions [Visit w3schools]
How to fetch the value of a particular namespace ignoring it's namespace?
How to fetch value of the 4th element (i.e. '<e>4</e>') from the above XML which has been repeated 5 times?
How to fetch value of that element which has 'attrib' value as 'a'?
What is namespace?
How many types of namespaces?
Target vs default namespace?
SOA Concepts:-
---------------------What is SOA?
Difference between SOA and ESB?
What are the key features of SOA Suite 11g and BPM Suite 12c
BPEL:-
-------
Explain error handling in BPEL
What is fault-binding and fault-policies file [what, why and how]
When an exception occurs how BPEL engine handles that [sequence in which it is handled]
How business faults are handled in BPEL
What are the transaction properties in BPEL
What is dvm (data value map) and how/where it is used?
How to send email using BPEL service?
How to configure smtp for sending emails?
Synchronous vs Asynchronous vs OneWay Service?
How to call another service (BPEL or BPM or OSB or any SOAP/REST Service) from BPEL?
What is MDS and types of MDS (Db-based vs File-Based)?
XSLT:-
-------
Xslt vs XQuery?
Name few functions in XSLT?
How to remove extra spaces from an element's value while mapping it to some target element?
What is template in XSLT?
How to create and call a template in XSLT?
How to pass a data explicitly into XSLT?
How to create a variable and assign value to that variable in XSLT?
How to put loops and conditions in XSLT?
How to add namespaces in XSLT?
XSD/Schema:-
-------------
What is Schema/EnterpriseObject?
How to create nested elements in an XSD?
What is complexType in XSD
How to define an element in XSD so that it can occur any number of times in corresponding XML
How to create fix length elements in XSD
How to put enumerated values for any element in XSD
Can we import another XSD inside one XSD? If yes then how? If no then why?
WSDL:-
-------
What is WSDL -WSDL vs WADL
How many types of WSDL
Concrete vs abstract WSDL
What are the elements/components of these WSDLs
What is the use of having these 2 types of WSDL
How service knows about the actual endpoints to hit at runtime. What changes need to be done and where?
What do you mean by port and binding. Difference?
Adapters:-
------------
How many adaptors have you worked?
If we have to call a webservice through BPEL, OSB and BPM; which will need an adaptor to configure?
Which adapter to configure in above course of action and what info we need to configure the same?
How to read a file using BPEL and OSB?
What are the operations given in File adapter?
What are the operations given in FTP adapter?
How to pass file name dynamically at run time to file adapter?
What are the operations given in DB adapter?
Can we perform two operations using just one DB-adapter? If yes then how? If no then why?
How to configure AQ Adapter?
How to configure MQ Adapter?
OSB (Oracle Service BUS):-
-----------------------------
Explain error handling in OSB
Explain business faults and how to handle them
What is 'transport header'
How to make call to a REST based service through OSB? What are the pre-requisites?
What are the context variables in OSB
Difference between Raise, Skip and Resume
'Routing options' Action in OSB.
Then, What is QoS (Quality of service) in OSB, which one is default QoS for ServiceCallout and Route respectively
Difference between routing, publish, service callout
What things we cannot do using osb which we can not do using bpel?
How to configure smtp for sending emails through OSB?
Jms queue -what is this, how to configure jms queue
Jms vs aq vs mq
How to run db queries using xquery
How to know the name of inbound/outbound operation dynamically and write in log while running an osb service?
What is result cashing in OSB?
How to maintain sessions in OSB?
What is 'Operational Branch' in OSB and how it works?
What is 'Conditional Branch' in OSB and how it works?
What is 'Dynamic Routing' in OSB and how does it happen?
What is 'Routing Table' in OSB and how does it work?
What is 'Dynamic Publish' in OSB and how does it work?
'Insert' vs 'Delete' actions? How are they used? Give examples.
How 'Validate' works? If validation fails then will it be a business fault?
'Assign' vs 'Replace'?
What are the various levels of 'Log' in OSB?
How 'Alert' and 'Report' actions work in OSB?
XQuery:-
--------------
xslt vs xquery
Name few functions in XQuery
How to create and call a function in XQuery
How to run db queries using xquery
How to pass a variable data explicitly into XQuery apart from body data
How to create and assign a variable in XQuery
How to put loops and conditions in XQuery
How to add namespaces in XQuery
Weblogic:-
------------
Jms queue -what is this, how to configure jms queue (Steps)?
Difference between Queue and Topic (How to create and How to use)?
JmsQueue vs AQ vs MQ?
Where does an AQ get created?
How to create an AQ?
How to create domains?
What is managed server?
What is cluster?
How to start admin and managed servers using commands?
How to enable SSL ports for services deployed?
Other SOA Components:-
-----------------------
What is BPM?
What is Business Rules? How it works?
What is Human Task and where/how it is used?
What is mediator?
How to implement error handling in BPM and Mediator components?
Here are few interview questions in various topics of your need..
XML Basics:-
<elements>
<e>1</e>
<e attrib='a'>2</e>
<e>3</e>
<e>4</e>
<e>5</e>
</elements>
What is XPath?
XPath related tricky questions [Visit w3schools]
How to fetch the value of a particular namespace ignoring it's namespace?
How to fetch value of the 4th element (i.e. '<e>4</e>') from the above XML which has been repeated 5 times?
How to fetch value of that element which has 'attrib' value as 'a'?
What is namespace?
How many types of namespaces?
Target vs default namespace?
SOA Concepts:-
---------------------What is SOA?
Difference between SOA and ESB?
What are the key features of SOA Suite 11g and BPM Suite 12c
BPEL:-
-------
Explain error handling in BPEL
What is fault-binding and fault-policies file [what, why and how]
When an exception occurs how BPEL engine handles that [sequence in which it is handled]
How business faults are handled in BPEL
What are the transaction properties in BPEL
What is dvm (data value map) and how/where it is used?
How to send email using BPEL service?
How to configure smtp for sending emails?
Synchronous vs Asynchronous vs OneWay Service?
How to call another service (BPEL or BPM or OSB or any SOAP/REST Service) from BPEL?
What is MDS and types of MDS (Db-based vs File-Based)?
XSLT:-
-------
Xslt vs XQuery?
Name few functions in XSLT?
How to remove extra spaces from an element's value while mapping it to some target element?
What is template in XSLT?
How to create and call a template in XSLT?
How to pass a data explicitly into XSLT?
How to create a variable and assign value to that variable in XSLT?
How to put loops and conditions in XSLT?
How to add namespaces in XSLT?
XSD/Schema:-
-------------
What is Schema/EnterpriseObject?
How to create nested elements in an XSD?
What is complexType in XSD
How to define an element in XSD so that it can occur any number of times in corresponding XML
How to create fix length elements in XSD
How to put enumerated values for any element in XSD
Can we import another XSD inside one XSD? If yes then how? If no then why?
WSDL:-
-------
What is WSDL -WSDL vs WADL
How many types of WSDL
Concrete vs abstract WSDL
What are the elements/components of these WSDLs
What is the use of having these 2 types of WSDL
How service knows about the actual endpoints to hit at runtime. What changes need to be done and where?
What do you mean by port and binding. Difference?
Adapters:-
------------
How many adaptors have you worked?
If we have to call a webservice through BPEL, OSB and BPM; which will need an adaptor to configure?
Which adapter to configure in above course of action and what info we need to configure the same?
How to read a file using BPEL and OSB?
What are the operations given in File adapter?
What are the operations given in FTP adapter?
How to pass file name dynamically at run time to file adapter?
What are the operations given in DB adapter?
Can we perform two operations using just one DB-adapter? If yes then how? If no then why?
How to configure AQ Adapter?
How to configure MQ Adapter?
OSB (Oracle Service BUS):-
-----------------------------
Explain error handling in OSB
Explain business faults and how to handle them
What is 'transport header'
How to make call to a REST based service through OSB? What are the pre-requisites?
What are the context variables in OSB
Difference between Raise, Skip and Resume
'Routing options' Action in OSB.
Then, What is QoS (Quality of service) in OSB, which one is default QoS for ServiceCallout and Route respectively
Difference between routing, publish, service callout
What things we cannot do using osb which we can not do using bpel?
How to configure smtp for sending emails through OSB?
Jms queue -what is this, how to configure jms queue
Jms vs aq vs mq
How to run db queries using xquery
How to know the name of inbound/outbound operation dynamically and write in log while running an osb service?
What is result cashing in OSB?
How to maintain sessions in OSB?
What is 'Operational Branch' in OSB and how it works?
What is 'Conditional Branch' in OSB and how it works?
What is 'Dynamic Routing' in OSB and how does it happen?
What is 'Routing Table' in OSB and how does it work?
What is 'Dynamic Publish' in OSB and how does it work?
'Insert' vs 'Delete' actions? How are they used? Give examples.
How 'Validate' works? If validation fails then will it be a business fault?
'Assign' vs 'Replace'?
What are the various levels of 'Log' in OSB?
How 'Alert' and 'Report' actions work in OSB?
XQuery:-
--------------
xslt vs xquery
Name few functions in XQuery
How to create and call a function in XQuery
How to run db queries using xquery
How to pass a variable data explicitly into XQuery apart from body data
How to create and assign a variable in XQuery
How to put loops and conditions in XQuery
How to add namespaces in XQuery
Weblogic:-
------------
Jms queue -what is this, how to configure jms queue (Steps)?
Difference between Queue and Topic (How to create and How to use)?
JmsQueue vs AQ vs MQ?
Where does an AQ get created?
How to create an AQ?
How to create domains?
What is managed server?
What is cluster?
How to start admin and managed servers using commands?
How to enable SSL ports for services deployed?
Other SOA Components:-
-----------------------
What is BPM?
What is Business Rules? How it works?
What is Human Task and where/how it is used?
What is mediator?
How to implement error handling in BPM and Mediator components?
