Infosys Certified Oracle Cloud Technical Consultant
Practice with real exam-pattern questions for Infosys Certified Oracle Cloud Technical Consultant. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Oracle Cloud Technical Consultant practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Oracle Cloud Technical Consultant certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
A customer Andreas Inc., has a reporting requirement provided to the implementation partner. What should be the most appropriate strategy recommended to the customer for Reporting development? a. Recommend development using OTBI always and confirm non-feasibility for any reports not possible to develop using OTBI b. Recommend development using BI Publisher always c. Analyze on what fields can be achieved through OTBI and follow a hybrid approach with fetching rest of the fields using BI Publisher d. Analayze if the requirement can be satisfied by a delivered Report and then recommend a fitment using either OTBI or BI Publisher
- ✓ a only Correct
- B b only
- C a or c
- D d only
- E c or d
- Question 2
Select the appropriate options for achieving an OTBI Report with cross-subject areas? a. Select all the required Subject Areas and the required columns from each of them and select at least one field from the folder common in each Subject Area b. Select all the required Subject Areas and the required columns from each of them and select at least one Fact column from each Subject Area c. Select all the required Subject Areas and the required columns from each of them d. We cannot achieve OTBI report with multiple Subject Areas
- ✓ a only Correct
- B b only
- C a or b
- D c only
- E None of the above
- Question 3
Assume PERMANENT_FLAG is a database item available to the fast formula. Which of the following statement is correct? DEFAULT FOR PERMANENT_FLAG IS 'x' IF PERMANENT_FLAG WAS DEFAULTED THEN (PERMANENT_FLAG = 'N') RETURN PERMANENT_FLAG
- ✓ This formula code is valid: Correct
- B We can't have DEFAULT statement in formula code
- C We can't have RETURN statement in formula code
- D This formula code is not valid
- Question 4
Modularization in fast formulas:
- ✓ Cannot be done as this is not a programming language Correct
- B Can be done using custom formula functions
- C Can be done using multiple fast formulas for different functions and calling them from a root formula
- D Both b and c
- Question 5
In a fast formula, global value:
- ✓ Never changes Correct
- B Changes daily
- C May change
- D Changes only if it has global affect
- Question 6
In a fast formula, return statement is:
- ✓ Must Correct
- B To be avoided
- C Recommended for efficient value retrieval
- D Deprecated from version 10
- Question 7
What are the various METADATA objects that MUST be included while loading a Worker using HCM Data Loader?
- ✓ Worker, PersonName, WorkRelationship, WorkTerms, and Assignment Correct
- B Worker, WorkRelationship, WorkTerms and Assignment
- C Worker, PersonName, WorkTerms and Assignment
- D PersonName, WorkRelationship, WorkTerms and Assignment
- Question 8
See below the History of a Job Object:
Now below is the File Line included in the input HDL file for the above Job.
SET PURGE_FUTURE_CHANGES N
METADATA|Job|SourceSystemId|EffectiveStartDate|EffectiveEndDate|RegularTemporary
MERGE|Job|45346|2011/03/04|2014/04/04|R
What all historical lines of the Job business object will get updated due to the above?
a. 1 only
b. 1, 2, and 3
c. Two new date effective splits will get inserted – with Eff. Start Date of 2011/03/04 after ‘1’ and the other as 2014/04/05 after ‘3’
d. No impact to the Job History- ✓ a only Correct
- B b only
- C c only
- D a and b
- Question 9
A customer Inatoli Inc., is implementing Oracle HCM Cloud in US and UK regions. There is a requirement to also load Payroll Relationships for this customer. Choose the correct option w.r.t loading the Payroll Relationships using Payroll Batch Loader:
- ✓ A single input file with both US and UK entries can be prepared and loaded Correct
- B Two separate input files for US and UK entries must be prepared and loaded
- C It is not possible to load Payroll Relationships using Payroll Batch Loader
- D None of the above
- Question 10
A customer Andreas Inc., has implemented Oracle HCM Cloud in 2017. Now in 2018, there is a need for transferring some employees in bulk to a different Legal Employer. Choose the correct option w.r.t. this activity assuming this transfer is carried out using HCM Data Loader:
- ✓ Prepare the data file containing the METADATA - Worker, PersonName. WorkRelationship, WorkTerms and Assignment and then load the data Correct
- B Prepare the data file containing the METADATA - Work Relationship, WorkTerms and Assignment and load the data with action code 'TRANSFER'
- C Prepare the data file containing the METADATA - Work Relationship, WorkTerms and Assignment and load the data with action code 'GLB_TRANSFER'
- D It is not possible to transfer the employees to a different Legal Employer using HCM Data Loader
More in Oracle Enterprise Applications
Infosys Certified PL-SQL Associate
Infosys Certified Oracle B2B Service Cloud Consultant
Infosys Certified Oracle Financial Consolidation and Close Cloud Services Consultant
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.