Thursday, August 6, 2015

ORACLE BAM INTERVIEW QUESTIONS


                                                                                                            PAVAN KUMAR         
Question: What is BAM and why we use it?
Answer:  BAM stands for Business Activity Monitoring.  This monitors various types of business activities, reports on them and sends out alerts when thresholds are reached or surpassed.

Question: what are the features of BAM?
Answer:  Below are the features of BAM.
  • With BAM, end users, operational managers and to some extend analysts get a real-time overview of the state of ongoing affairs.
  • It is required to improve decision-making processes.
  • It is also used to understand Key Performance Indicators (KPI) affecting processes

Question: What are different components of BAM?
Answer:  BAM has 4 components.
  • Active Viewer
  • Active Studio
  • Architect
  • Administrator

Question: Explain each component.
Answer:
Active Viewer

  • Oracle BAM Active Viewer is the thin user interface for the business user.
  • When new, information is available; the user receives an instant message that contains a link to the information.
  • The user opens Active Viewer through this link and a report is displayed.
  • Report formats include charts, columns, cross tab, spread sheets, KPIs, lists and more.
  • These different formats can be combined in one report or viewed in separate reports.
Active Studio
  • Oracle BAM Active Studio is the thin user interface for the power user.
  • Through Active Studio, the power user can create and edit reports.
  • Report creation includes field selection, formatting, filtering, calculated fields, and summaries.
  • Reports may be published and rules can be created for determining the scheduling and delivery of the reports.
  • View types include: charts, columnar, cross tab, spread sheets, KPIs, lists and more.

Architect
  • Oracle BAM Architect is the thin user interface for the data designer focused on creating data objects in the Oracle BAM Active Data Cache so that power users can create reports.
  • Through Oracle BAM Architect, the data designer creates data objects, creates and schedules data flow plans, imports and creates metadata, and maintains the data objects and rules.
  • Oracle BAM Architect is seamlessly integrated with Oracle BAM Active Studio.

Administrator
  • Oracle BAM Administrator is the thin user interface for the system administrator who is responsible for user management and overall server management.
  • Through Oracle BAM Administrator, the system administrator can add or delete users, define security levels for users and objects, manage the Oracle BAM Active Data Cache, and maintain and configure Oracle BAM services.

Question: What is Data Object?
Answer: Data objects are tables that store raw data in the database. Each data object has a specific layout which can be a combination of data fields, lookup fields, and calculated fields.

Question: How to get data from JMS queue/topic to BAM data object.
Answer: By using EMS (Enterprise Message Source).

Question: What is EMS?
Answer: Enterprise Message Sources (EMS) is used by applications to provide direct Java Message Service (JMS) connectivity to the Oracle BAM Server. Each EMS connects to a specific JMS topic or queue, and the information is delivered into a data object in the Oracle BAM Active Data Cache.

Question: Can we have user based access in BAM?
Answer: Yes, we can have user based access in BAM.

Question:  By how many ways we can do SOA service monitoring?
Answer: We can use below options available to monitor SOA service.
  • BAM Adapter
  • Sensors

Question: When we need to use BAM adapter?
Answer: BAM adapter is used when we want to do monitoring at composite level or when we need to monitor full message.

Question: When we can use Sensors?
Answer: Sensors are used when we want to do variable and activity level monitoring.

Question:  What is Sensor action?
Answer: Sensor action is linked to sensor. In sensor action we define what action we need to perform on sensor data.

Question: Types of sensor actions?
Answer: There are two types of sensor actions.
  • Sensor action
  • BAM sensor action

Question: Where we use sensor action?
Answer:  By using sensor action we can publish the sensor data to Database, JMS Queue/topic, Custom Java and JMS adapter.

Question: Where and when we use BAM sensor action?
Answer: We used this sensor when we need to directly send the sensor data to BAM data object.

Questions: What is BAM alert?
Answer:  Business Activity Monitoring has alert feature which we can use when we want to perform some action based on some data insertion or data change.

Question: Can we use BAM alert to invoke external web service?
Answer: Yes, we can use BAM alerts to invoke external web service.



                                                                                                  PAVAN KUMAR

ORACLE OSB QUESTIONS


                                                                                PAVAN KUMAR

To connect to source system which service we will use?
Answer: we will use Proxy service to connect to Source system.

To connect to target system which service we will use?
Answer: we will use Business service to connect to target system.
What is Proxy Service?
Answer: It is a service in OSB which is exposed to source system or application.
What is Business Service?
Answer: It is a service in OSB which is used to connect to target system.
What is Message Flow?
Answer: Message flow is there in proxy service, We do all types of transformation, routing and other processing message flow only.
Do we have global variable in OSB (Can we access variable which is defined in proxy service message flow from other proxy service message flow)?
Answer: No, we can't access variable in proxy service message flow from other proxy service message flow.
Can we use direct bindings to call SOA composites?
Answer: Yes, we can direct binding-bindings to call SOA composites along with SOAP bindings.
Where the file will go if there is any error while polling the file ?
Answer: During configuring file or ftp protocol in OSB, we need to specify error directory, so you can see file to that directory if file polling failed.
Why we use Split-Joins in OSB?
Answer: To do parallel processing.
Types of Split-Joins?
Answer: Static and dynamic.
How to call Java code from OSB?
Answer: By using Java callout activity.
Can we use more than one route node in message flow?
Answer: No, we can't we use more than one route node in proxy service message flow.

When we call asynchronous service from OSB then how to get response back from that asynchronous service to OSB?
Answer: Design the proxy service which in turn calls business service which in turn calls asynchronous service. In the message flow of this proxy change the message header to below.
You need to specify ReplyTo value so that asynchronous service response came to CallSyncCompositeProxy proxy service.

<soap-env:Header xmlns:ns1="http://schemas.xmlsoap.org/ws/2003/03/addressing">
<ns1:MessageID>ws:uniqueAddress</ns1:MessageID>
<ns1:ReplyTo>
<ns1:Address>http://localhost:8011/CallAsyncService/proxyServices/CallSyncCompositeProxy</ns1:Address>
</ns1:ReplyTo>
</soap-env:Header>
Remember ReplyTo address refers to CallSyncCompositeProxy endpoints.

What is throttling in OSB?
Answer: Throttling means we want to process certain messages in one time, then we need to set some parameters in OSB to do the required task.

to transform from binary to XML or XML to binary format what we will in OSB?
Answer: we use MFL.

can we use MDS in OSB?
Answer: No, Oracle Service Bus does not support MDS.

Can we use DVM’s in Oracle Service Bus?
Answer: No, we can’t use DVM’s in Oracle Service Bus

Question: How Security works in OSB?
Answer: Oracle Service Bus leverages Weblogic Security Framework.

Can we use OWSM to secure OSB services?
Answer: Yes, we can use OWSM to secure OSB services.

To secure OSB proxy service, which OWSM policy you will use?
Answer: To secure OSB proxy service, we use OWSM service side policy.

Can we invoke secure web service from OSB?
Answer: Yes, we can use OWSM client policy and invoke secured web service from OSB.
When we use service Account?
Answer: We use Service Account when we are invoking a service which required static authentication.

Can we re-use Service Account for other Business Services as well?
Answer: Yes, we can re-use the Service Account.

What is Transport-Level Security?
Answer:  It refers to transport protocol security means secure the connection over which messages are transferred. E.g. HTTPS means HTTP over SSL.

What is Message-Level security?
Answer: Message level security is used when we want to protect the message exchanged between two applications.
What is Service pooling in OSB?
Answer: In OSB we can group together more than one service so that whenever one service goes down, request will route to next available service and end user can continue his work without any interruption.

How file pooling works in OSB?
Answer: There are below two ways to poll a file in OSB.

·         Use OSB file protocol: We can use file protocol available in proxy service to poll the file.

·         Use File adapter: we can create file adapter in Jdeveloper and import JCA, WSDL & XSD file of that adapter into OSB and generate proxy service from that.

Types of pipeline available in OSB?
Answer: We have two pipelines in OSB, Request and Response pipeline.


Can we invoke Restful service from OSB?
Answer: Yes, we can invoke Restful service from OSB.

When we use service Account?
Answer: We use Service Account when we are invoking a service which required static authentication.

We don’t have any DB protocol in OSB then how to read/write data from database using OSB?
Answer: We can use database adapter to read/write data from database. We can create database adapter in Jdeveloper, import adapter JCA,WSDL & XSD files to OSB and generate proxy or business service as per our requirement.

How to perform file listing in OSB?
Answer:  To perform file listing in OSB, you need to create file adapter with file listing operation in Jdeveloper and use that only.

What is Service Result caching in OSB?
Answer: Service Result Caching is one of the options that you can use when you want to improve Oracle Service Bus performance. Service Result caching is used when we have business service which connects to external service which returns somewhat static response. So by using Service Result Caching we don’t hit external service for same request instead it will take the response from cache which improve the OSB performance

How to perform Service Callout in OSB?
Answer: We use Service Callout option inside Oracle Service Bus to call any service inside message flow to get the required data. In this post, I will show you how to use Service Callout activity in Oracle Service Bus and pass the response from callout service to next service


When we invoke proxy 2 from proxy 1 then which protocol we need use?
Answer: When there is internal proxy call in OSB then we use “local” transport instead of HTTP.
What is content based routing in OSB?
Answer: When we route the request message to different business services based on request message content, that is called content based routing.


What are different options available in OSB to read flat file?
Answer: We can read flat file in two different ways.

·         Using MFL: we can MFL in OSB to read flat files.

·         File Adapter: Create file adapter which read flat file in Jdeveloper, copy JCA, WSDL & XSD file of file adapter in OSB and create proxy service which will read that flat file.

What is SLA alert in OSB?
Answer: A service-level agreement (SLA) is a contract between a service provider and a service consumer. In OSB monitoring framework we have SLA alerts which come into picture when there is violation of service level agreements.

How to move large file without reading it in OSB?
Answer:  In Oracle SOA Suite we use “Move” operation to move large files from one location to another. But in Oracle Service Bus we don’t have that option available. But we can use Content Streaming option available for file protocol in OSB to move large files.

By how many ways we can do OSB development ?
Answer: We can do development in OSB by two ways. Either we can use Eclipse which is IDE tool for OSB or we can use SB console for the development.

Will you prefer Eclipse or SB console for OSB development ?.
Answer: It is simple to work with SB console as compared to eclipse, so during initial phase we can opt for SB console and later go for eclipse. When we work at enterprise level, Eclipse is always recommended.

Do we need to create a session when we develop projects in Eclipse ?
Answer: No, we need not to create a session when we develop projects in Eclipse, session will only come into picture when we deploy the project to server from eclipse.

Can multiple users work on SB console at one time?

Answer: Yes, multiple users with different users can work on SB console at same time as session will be created for each users individually.

Can we test the proxy service from Eclipse ?

Answer: Yes, we can test the proxy service from Eclipse, for that we need right click on the proxy service and then click on Run As and run it on server.

Can we create Xquery transformation in design mode in SB Console ?
Answer: No, we have to write Xquery in source mode. We can create Xquery transformation in Eclipse.

Do we have the option to test the Xquery Transformation ?
Answer: Yes, we can test the Xquery transformation.

Can we use XSLT file in OSB ?
Answer: Yes, OSB support both Xquery and XSLT.

What is Message Flow ?
Answer: Message Flow is OSB component which is part of proxy service. We define our business logic in message flow.

Can we delete Start Node in Message flow ?
Answer: Start Node comes default in message flow once we create a proxy service. Every message flow will always have a start node and we can't delete the start node in message flow.
Can we add multiple pipeline pair in one message flow ?
Answer: Yes, we can add more than one pipeline pair in one message flow.

Can we directly add actions under request or response pipeline ?
Answer: No, we can't add actions directly under request or response pipeline, we need to add stage node in request or response pipeline and inside that stage, we can add all required actions.

Can we have more than one route node in message flow ?
Answer: No, we can't add more than one route node in message flow.

Which node you will use when you need to route the message based on content ?
Answer: We will use Conditional Branch to route the message to different business services based upon content, this is also called content based routing.

Which node you will use to route the message based upon operations ?
Answer:  We will use operation Branch to route the message to different business services  based upon operation.

Can we delete the default branch in conditional or operational branch ?
Answer: No, we can't delete the default branch in conditional or operational branch.

Can we add more than one route in one conditional or operation branch ?
Answer: Yes, if we more than one branch then we add one route node in each branch as each branch will be independent and only one branch will execute at one time.

Can we add stage node under route node ?
Answer: No, we can't add stage node under route node. Stage node can be added only under request and response pipeline or in error handlers.

What is Dynamic Routing action ?
Answer: This action is used when we need to route the message to business service dynamically that means at design time we don't know to which business service we have to route the message and that is determined at run time.

Which action we use to throw fault/error in message flow ?
Answer:  We use "raise-error" action to throw business fault in message flow.

What is reply action ?
Answer: It specify that immediate reply is sent to invoker.

What actions we use for OSB reporting ?
Answer: We use Alert, Log and Report for OSB reporting.

Can we change the file name in message flow at runtime ?
Answer: Yes, we can change filename at runtime using Transport Header action.

Can we change the endpoint URI of the external service that we invoke using business service ?
Answer: Yes, we can do it by using routing option action.



                                                                                 PAVAN KUMAR