Anyone who is interesting to build a career in Oracle Integration Cloud and become an Integration specialist would have come across Oracle Integration Cloud Interview Questions on multiple occasions. As we know, Oracle Integration Cloud (OIC) is a platform that integrates across cloud and on-premise applications and simplifies connectivity between key 3rd party enterprise applications and on-premise applications.
An Oracle Integration Cloud specialist is responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems.
To help you out, we have acquired some of the Top 40+ OIC Interview Questions and Answers, and they will definitely help you progress forward in Oracle Integration Cloud.
OIC Interview Questions and Answers
Q1. What is Oracle Integration Cloud (OIC)?
Ans: Oracle Integration Cloud (oic) is a Middleware platform offered by Oracle. This enables communication between multiple applications. All types of applications SaaS, on-premises can be integrated using OIC. OIC offers three applications:
1. Integration Cloud Service (ICS)
2. Process Cloud Service (PCS)
3. Visual Builder Cloud Service (VBCS)
Q2. Oracle Integration Cloud comes under which category of Cloud?
Ans: Oracle Integration Cloud is Platform as a Service (PaaS)
Q3. What is Integration in Oracle Integration Cloud?
Ans: Integrations are the main ingredient of Oracle Integration. An integration includes at the least a trigger (source) connection (for requests sent to Oracle Integration) and invokes (target) connection (for requests sent from Oracle Integration to the target) and the field mapping between those two connections.
Q4. What is an adapter in Oracle Integration Cloud?
Ans: OIC adapter is an abstract way to connect to any application with the help of the box adapter. There are 50+ adapters available in OIC. Those are categorized as
- Oracle Adapter (Oracle Sales Cloud, Oracle EBS, Oracle ERP adapter, etc.)
- Non-Oracle Adapter (Salesforce, Ariba, Concur, etc.)
- Technology adapter(REST, SOAP, FTP, etc.)
Q5. How many design patterns are available in OIC and what are those?
Ans: There is a total of six patterns in Oracle Integration Cloud are:
- App Driven Orchestration
- Scheduled Orchestration
- File Transfer
- Basic Routing
- Publish To OIC
- Subscribe To OIC
Q6. What is App Driven Orchestration Pattern?
Ans: App Driven Orchestration pattern is a multi-step pattern, that allows invoking multiple applications in a single flow, doing a for-each loop, if-else logic, applying complex logic, etc.
Q7. What is a Scheduled Orchestration Pattern?
Ans: Scheduled Orchestration pattern allows you to develop an integration that can run on a pre-defined frequency and can be executed on an Ad hoc basis.
Q8. What is a File Transfer Pattern?
Ans: The File Transfer pattern allows moving files across the network seamlessly and securely. This is again a scheduled type of pattern.
Q9. What is a Basic Routing Pattern?
Ans: A basic Routing pattern can connect only two applications with no logic.
Q10. What is Publish To OIC and Subscribe To OIC pattern?
Ans: Publish To OIC pattern allows publishing messages to OIC internal messaging queues. For example, an event can be subscribed from Oracle Sales Cloud and published the same into Oracle Integration Cloud messaging queue. Subscribe To OIC pattern subscribes messages from Oracle Integration Cloud messaging queue and sends the same to different applications. These queues are managed by OIC itself and you don’t have access to them.
Q11. What is Lookup in Oracle Integration Cloud?
Ans: Lookups associate values used by one application for a specific field to the values used by other applications for the same field. This provides the capability to map values across vocabularies or systems. For example, the source application uses country code to represent the country however target application uses the country name to represent the country. These mapping can be maintained using Lookup and will be referred by Integration during runtime.
Q12: What is mapper?
Ans: A visual mapper is provided that enables you to map fields between applications with
different data structures by dragging source fields onto target fields.
Q13: What Mapper function can you use to get the lookup value in Mapping Builder?
Ans: LookupValue
Q14: What is Business Identifier in Oracle Integration Cloud?
Ans: Business identifiers enable you to track payload fields in messages during runtime. You
can specify up to three business identifier fields for tracking during design time. One of these
fields must be selected as the primary business identifier field.
Q15: Can we store data into OIC?
Ans: OIC doesn’t allow you to store data for future use. However, OIC is having Stage activity
that can be used to store data for temporary use. The data stored in OIC is flushed
automatically as soon as the instance is completed.
Q16: How to handle exceptions in Oracle Integration Cloud?
Ans: Exception can be handled using Scope activity and Global Fault handler in Oracle Integration Cloud. Fault Handlers are provided at the scope level to handle errors that arise during invoke actions within those scopes. Global Fault Handler is available at the overall integration flow level which acts as a super catch block.
Q17: What is a connectivity agent?
Ans: The connectivity agent is the agent that helps you create integrations between on-premises applications and SaaS applications. Connectivity Agent acts as a Gateway from On-premise to OIC.
This agent is installed and runs on an on-premises environment on the same network as internal systems such as Oracle E-Business Suite, Oracle Siebel, Oracle Database, and others.
Q18: What is the timeout limit of the connectivity agent?
Ans: The timeout limit is 240 seconds. If the request and response don’t complete within 240 seconds then the transaction will get timed out and integration will not succeed with the below error:
oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240seconds of wait
interval
Q19: What is the payload limit of the connectivity agent?
Ans: 10 MB is the message payload limit on the Agent side. This means that if the message payload is more than 10MB of a single request the transaction will fail.
Q20: What is the difference between FTP and File adapter?
Ans: FTP adapter can read/write files from FTP/SFTP which are accessible over the internet however File
adapter allows read/write files from FTP/SFTP which is behind the firewall.
FTP adapter can’t poll files from the FTP server however File adapter has polling capability.
Q21: What are the retention period and default retention period of a Database in OIC?
Ans: The retention period is defined as the time duration for which the success/failed instance can be tracked from the OIC dashboard. The default retention period is 3 days for success and faulted instances however this limit can be increased or decreased depending on the requirement.
Q22: What are a feature flag in OIC and the life cycle of the feature flag?
Ans: Oracle Integration Cloud allows enabling specific functionality to a specific OIC instance as required which is called the feature flag model. The codebase will remain the same for all instances but the feature flag control the features. The flag life cycle involves 4 steps:
- Internal Only
- Featured Controlled
- Feature Controlled General Availability
- General Availability (GA)
Q23: How many types of certificates can be imported from the Settings menu and what are those?
Ans: Three types of certificates can be imported into OIC that is used to validate outbound SSL
connections are:
- Identity Certificate
- Trust Certificate
- Message Protection Certificate
Q24: What is the difference between ICS and OIC?
Ans: Integration Cloud Service (ICS) simplifies how you build integrations in the cloud. This product lets you connect securely to applications and services both in the cloud and on-premises. The infrastructure (cloud management, patching, backup, and restore) is managed by Oracle.
Oracle Integration Cloud (OIC) contains:
- Integration Cloud Service (ICS)
- Process Cloud Service (PCS) – A process automation tool used to design, automate and manage business processes in the cloud.
- Visual Builder Cloud Service (VBCS) – This allows you to rapidly create and deploy web and mobile applications directly from the browser with minimal coding required.
Q25: What is the CSF key?
Ans: CSF keys are credentials used for basic authentication (user name and password) to certify the authority of users and system components. Certificates are electronic documents used to authenticate an individual or organization.
Q26: What do you understand from the term utility computing?
Ans: Utility Computing is regarded as one of the cost-saving strategies by many businesses in need of cloud services. In Oracle Fusion, it is possible for the users to pay for the service they are taking on a per-use basis. All the organizations that consider growth and scale models can benefit from this.
Q27: What is the distinction between SOAP and REST API?
Ans: SOAP vs REST API
SOAP (Simple Object Access Protocol) is a protocol that was developed prior to the implementation of REST. Its main aim was to make it easier for writing programs on a variety of platforms and programming languages to share data. The term SOAP refers to the Simple Object Access Protocol.
REST (Representational State Transfer) was created with the purpose of interacting with media elements, files, and even artifacts on a specific hardware unit. For working with the necessary components, a Restful service will use the standard HTTP verbs like GET, POST, PUT, and DELETE.
Read more about SOAP vs REST APIs in this blog
Q28: What are the limitations of the FTP adapter?
Ans: ‘Read a File’ operation of the FTP adapter allows reading files of less than 10MB only. So to read files greater than 10MB users will have to use the ‘Download File’ operation and also the adapter doesn’t allow to poll new files from the FTP server.
Q29: Can we install the OIC connectivity agent in High Availability(HA) mode?
Ans: Yes, the agent can be installed in HA mode. Agent HA provides users with an option to run multiple OIC Agents in Active-Active mode.
Q30: What are the prerequisites to install a connectivity agent?
Ans: Satisfy the system requirements before installing the connectivity agent.
1. The Agent is certified with Oracle JDK Version 8.
2. The agent is certified on the following operating systems
- Oracle Enterprise Linus 6.x, 7.2 and 7.5
- RedHat Enterprise Linux 6.6, 7.2 and 7.5
- Use Linux Enterprise Edition 12 SP2
- Windows Standard Edition 2016
3. 8GB Memory with 4GB of heap size dedicated for the agent JVM
Q31: What is the difference between OIC & SOACS?
Ans: OIC is mainly used to integrate SaaS & On-premise applications and is more pattern-driven like map my data, and orchestration. OIC has a web-based UI that is very friendly and has drag/drop capabilities.
SOA Cloud Service provides you with an Integration platform as a service. The environment is built automatically and instantly in a few clicks, providing more time to develop or deploy SOA Composite applications and Service Bus projects. SOACS offers real-time analytics while you move to Digital Business
Read more about OIC and SOA CS in this blog.
Q32: Can OIC integrate with on-premise applications to the Oracle cloud?
Ans: Yes, this can be achieved using OIC Connectivity Agent that enables you to create integrations and exchange messages between on-premises applications and OIC Service.
Q33: How do Compartment and Policies differ from each other?
Ans: A compartment is a logical container in which the OCI resources reside and provides appropriate access to various resources in OCI. In a compartment, users can have sub-compartments whereas Policies are statements specifying which user or group has what access to the resources in OCI.
Q34: What are the two types of integration licenses?
Ans: The integration licenses are:
- Subscribe to a new Oracle Integration License: This provides you with message packs of size 5K per hour which can be extended up to 12 sets of 5k message packs so, in total, you can get a maximum of 60K messages.
- Use my Existing Oracle Fusion Middleware license with Oracle Integration (BYOL): Also known as bring your own license (BYOL), provides you with message packs of size 20K per hour.
Q35: What is OAuth?
Ans: OAuth is a way to protect web services. Here you get a policy that can be attached to a web service, and when a request comes to service, it will ask for an OAuth token to allow that request.
Q36: What is ATP Database?
Ans: ATP stands for Autonomous Transaction Processing which is built on the same autonomous database as the Autonomous Data warehouse (ADW). It is a self-driving database built to run a complex mix of high-performance databases, along with other workloads like IoT, reporting, batch jobs, Real-time analytics, and Machine learning.
Download the Complete 40+ Oracle Integration Cloud OIC Interview Questions & Answers 2023
When you have tested your knowledge by answering these oracle integration cloud interview questions, I hope you have a clear stand regarding your OIC interview preparation.
Note: K21Academy also offers a complete Oracle Integration Cloud (OIC) Interview Preparation Questions Prep Guide where learners get to practice questions to test their OIC knowledge before the actual interview.
To download the complete 40+ OIC Sample Interview Questions & Answers click here.
Make sure to check out K21 Academy’s OIC Online Training program if you want to become an integration expert and become skilled in all of the ideas associated with it. You may learn all of the ideas extensively here, as well as get a course certificate.
If you found these Oracle Integration Cloud Interview Questions and Answers helpful, please let us know in the comments area.
Related Links/References:
- Oracle Integration Cloud (OIC) For Beginners Overview
- 1Z0-1042-21 Oracle Cloud Platform Application Integration 2021 Specialist
- OIC Step By Step Activity Guides/Hands-On Lab Exercise
- Oracle Integration Cloud (ICS, PCS, VBCS) Console Walkthrough
- Create OIC Instance: Step-by-Step
- OIC Expert Phil Wilkins Interview Questions
- Difference between OIC and SOA CS
- Oracle Integration Cloud Interview Questions Free Guide
-
-
Next Task For You:
Begin your journey toward becoming an Oracle [1Z0-1042] Certified Cloud Integration Expert by joining our FREE Class.
Leave a Reply