Infosys Certified L2 Junior Oracle BI Programmer
Practice with real exam-pattern questions for Infosys Certified L2 Junior Oracle BI Programmer. 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 L2 Junior Oracle BI Programmer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified L2 Junior Oracle BI Programmer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Where do you set the visibility permissions for the Dashboard
- ✓
Webcat
Correct - B
Rpd
- C
Both
- D
None of the above
- ✓
- Question 2
Which of the following is true about aggregation?
- ✓
Data in fact and dimension sources is stored at the lowest level of detail.
Correct - B
Analysis often requires rollup of detailed data
- C
Calculations and aggregation at runtime can be resource intensive.
- D
All of the above
- ✓
- Question 3
Mention the correct order for the implementation of BMM? 1. Define Measures 2. Create Logical tables 3. Create a new business model 4. Create logical joins 5. Create logical columns
- ✓
1,3,4,5,2
Correct - B
3,4,5,2,1
- C
5,2,3,1,4
- D
3,2, 5,4,1
- ✓
- Question 4
Which of the following repository table types holds the information of Daily Loads
- ✓
W_XXXX_DH
Correct - B
W_ETL_XXXX
- C
S_XXX
- D
WC_XXX_DS
- ✓
- Question 5
Object Level security is applicable to
- ✓
Answers Requests
Correct - B
Presentation layer objects
- C
Dashboards
- D
All of the above
- ✓
- Question 6
Which of the following is NOT one of the drivers in the decision to invest in a Business Intelligence solution?
- ✓
High Volumes of data being processed on the Transaction Processing systems and to reduce the load on them by not querying them during update.
Correct - B
Managing real time update of the system, in an optimized way, with transactions that happen across multiple locations with minimal redundancy.
- C
Business users need to be enabled with ability to perform Ad hoc analysis, in other words answer their business questions with minimal support from IT.
- D
Analyzing cross functional performance against bench marks and subsequent reasons behind any deviation from the expected.
- ✓
- Question 7
Which of the following are not the standard dimensional models?
- ✓
Star cluster
Correct - B
Constellation schema
- C
Galaxy Schema
- D
All of these
- ✓
- Question 8
What is an SCD in Data warehousing parlance?
- ✓
Synchronous Critical Dimension
Correct - B
Slowly Changing Dimension
- C
Synchronously Changing Dimension
- D
Slow Constant Dimension
- ✓
- Question 9
Please select the most appropriate answer based on the statements below: “Analytical schema of organizing data : (a)Is optimized for updating the Database (b)Has fewer joins than OLTP schema (c)Has lower redundancy
- ✓
Only B is true
Correct - B
Only a,c are true
- C
Only a,b are true
- D
Only C is true
- ✓
- Question 10
What is a complex join
- ✓
Join between two Dimension Tables
Correct - B
Join between two fact Tables
- C
Joins over non-foreign key and primary key columns
- D
All the above
- ✓
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.