Skip to content

Oracle Business Analytics Interview Questions & Answers

Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.

About Oracle hiring for Business Analytics roles

Oracle develops database software, cloud infrastructure (OCI), enterprise applications such as Fusion ERP and NetSuite, and industry software for banking and healthcare. India hosts major Oracle development and support centres, including Oracle Financial Services Software. It hires for software developers, QA engineers, database engineers, cloud support and data analytics roles.

For Business Analytics roles, this Oracle practice set focuses most on Excel for Business Analysts (7), Financial and Business Analysis (6), Business Metrics and KPIs (5), SQL for Business Analysis (5). It has 30 medium, 10 hard questions, so you can start easy and work up to the harder ones.

Company type
Product
Headquarters
Austin, Texas, USA
Main India offices
Bengaluru, Hyderabad, Noida, Mumbai, Pune

Oracle Business Analytics interview process

  1. Online assessment (aptitude + coding + CS MCQs)
  2. Technical round 1
  3. Technical round 2
  4. Managerial round
  5. HR round

Typical pattern based on public candidate experiences. Rounds vary by role, team and year.

Solved for OracleStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

Write Excel formulas for IRR with yearly cash flows and XIRR with irregular dates.

Save to ▾
Show answer
# Yearly cash flows in B2:B7, year 0 investment negative =IRR(B2:B7) # Irregular dates: cash flows in B2:B7, dates in C2:C7 =XIRR(B2:B7, C2:C7) # XIRR returns an annualised rate based on actual dates, # which suits SIP returns or projects with uneven payments.
02

Write non-functional requirements for an online payment page.

Save to ▾
Show answer
NFR-01 Performance: the payment page loads within 2 seconds for 95 percent of requests at 500 concurrent users. NFR-02 Availability: 99.9 percent monthly uptime outside planned maintenance. NFR-03 Security: card data is never stored by the application, and all traffic uses TLS 1.2 or higher. NFR-04 Compliance: the flow meets PCI DSS and RBI payment guidelines. NFR-05 Usability: works on mobile screens from 360 pixels wide. NFR-06 Audit: every transaction attempt is logged with a timestamp.
03

Your project is going to miss its deadline by two weeks. How do you communicate this?

Save to ▾
Show answer
Tell the sponsor and key stakeholders as soon as you are confident, not on the deadline. Be direct about the delay, the cause and the impact. Come with options, such as reducing scope to hit the date, adding resources, or moving the date with a phased release, plus your recommendation. Agree on the new plan, update the communication plan and track the recovery visibly.
04

How would you forecast next quarter's sales in Excel?

Save to ▾
Show answer
Use FORECAST.ETS or a trendline on monthly history, check seasonality, compare with a simple moving average and present a range, not a single number.
05

Write an Excel formula for a two-way lookup that finds sales for a given product and month.

Save to ▾
Show answer
// products in A2:A50, months in B1:M1, data in B2:M50 // G1 = product, G2 = month =INDEX(B2:M50, MATCH(G1, A2:A50, 0), MATCH(G2, B1:M1, 0)) // Excel 365 alternative =XLOOKUP(G1, A2:A50, XLOOKUP(G2, B1:M1, B2:M50))
06

A KPI on your dashboard dropped 40 percent overnight. What are your first steps?

Save to ▾
Show answer
Assume a data problem until proven otherwise, because real businesses rarely move 40 percent in a day. Check whether the refresh completed, whether source row counts look normal, and whether any tracking, pipeline or definition changed. Compare with a raw source query and a related metric, such as orders versus payments. If the data is fine, segment by channel, region and platform to locate the drop, then alert the owners quickly.
07

How do you find duplicate customers?

Save to ▾
Show answer
SELECT email, COUNT(*) FROM customers GROUP BY email HAVING COUNT(*) > 1;
08

Write a DAX measure that shows each category's percent share of total sales.

Save to ▾
Show answer
Category Share % = DIVIDE( [Total Sales], CALCULATE([Total Sales], ALL('Product'[Category])) ) -- ALLSELECTED instead of ALL respects slicers on the page
09

A feature was launched to all users at once without an A/B test. How would you measure its impact?

Save to ▾
Show answer
Use quasi-experimental methods. Compare before and after with enough history to account for trend and seasonality. If it rolled out at different times in regions or platforms, use difference-in-differences between early and late groups. Compare users who adopted with similar non-adopters using matching, while being careful about self-selection. For future launches, recommend keeping a small holdout group so impact can be measured cleanly.
10

What is the cash conversion cycle?

Save to ▾
Show answer
The cash conversion cycle measures how many days cash is tied up in operations. It equals days inventory outstanding plus days sales outstanding minus days payables outstanding. Example: inventory sits 40 days, customers pay in 30 days and suppliers are paid in 45 days, so the cycle is 40 + 30 - 45 = 25 days. A shorter cycle means less working capital is needed. Some marketplaces have a negative cycle because they collect from customers before paying sellers.
11

What is IRR and how is it different from NPV?

Save to ▾
Show answer
IRR (internal rate of return) is the discount rate at which a project's NPV becomes zero, so it expresses the return as a percentage. NPV gives the value created in rupees at a chosen discount rate. Accept a project if IRR exceeds the cost of capital or NPV is positive. When comparing projects of different size or timing, NPV is more reliable, because IRR ignores scale and can give multiple answers when cash flows change sign more than once.
12

A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?

Save to ▾
Show answer
Profit is an accrual figure, while cash depends on timing. Check working capital first: receivables may be growing because customers pay late, inventory may be piling up, or suppliers may be demanding faster payment. Then look at large capex, loan repayments, and dividends. Review the cash flow statement and compute days sales outstanding and inventory days over time. Fixes include tighter credit terms, collection drives, inventory reduction and renegotiating supplier terms.
13

How do you manage conflicting requirements from two senior stakeholders?

Save to ▾
Show answer
Clarify the underlying goals, present data and trade-offs, facilitate a joint session, escalate to the sponsor if needed and document the agreed decision.
14

How are OKRs different from KPIs?

Save to ▾
Show answer
KPIs are ongoing health measures of the business, like monthly revenue, churn or on-time delivery, tracked continuously. OKRs are a goal-setting method: an Objective is a qualitative ambition for a quarter, and Key Results are two to four measurable outcomes that show it was achieved. A KPI that is off track often becomes the subject of an OKR, for example 'reduce churn from 5 to 3 percent this quarter'.
15

How do you calculate cycle time, touch time and process efficiency? Give an example.

Save to ▾
Show answer
Cycle time (lead time) is the total elapsed time from the start to the end of a case. Touch time is the time someone actually works on it. Process cycle efficiency is touch time divided by cycle time. Example: a refund takes 5 working days (40 working hours) end to end, but the agents spend only 2 hours in total working on it. Efficiency is 2 / 40 = 5 percent, so 95 percent of the time is waiting, and queues are the main target.
16

How would you decide whether to launch a new product?

Save to ▾
Show answer
Assess market size and demand, customer need, competition, unit economics, capabilities, risks and strategic fit, then test with a pilot before scale-up.
17

What is the difference between Definition of Ready and Definition of Done?

Save to ▾
Show answer
Definition of Ready is a checklist a story must meet before the team pulls it into a sprint: clear description, acceptance criteria, dependencies identified, designs attached and estimated. Definition of Done is the checklist for calling work complete: coded, reviewed, tested, acceptance criteria passed, documented and deployable. The BA mostly drives readiness, while the whole team owns done. Both reduce rework and arguments at sprint end.
18

The sales team keeps hitting its revenue target, but company margins are falling. What would you recommend?

Save to ▾
Show answer
The incentive rewards revenue regardless of profitability, so reps are likely discounting heavily or pushing low-margin products. Analyse deal-level discount, product mix and margin by rep and region to confirm. Then recommend changing the target to gross margin or contribution, or adding discount approval limits and a margin floor to commission. Pilot the new plan with one region and track revenue, margin and win rate together.
19

Tell me about a dashboard you built that changed a business decision.

Save to ▾
Show answer
Situation: regional sales heads reviewed discount spend only at month end. Task: I was asked to give weekly visibility. Action: I built a Power BI report linking discounts to margin by product and region, with a drill-through to deal level and an alert when margin fell below target. Result: the team spotted two regions giving deep discounts on low-margin items, tightened approval rules, and margin improved by about two points the next quarter.
20

How do you build a forecast in Excel?

Save to ▾
Show answer
Use historical data with FORECAST.ETS or trend lines, state assumptions, compare against actuals and show best, base and worst scenarios.
21

How do you find the top 5 customers by revenue?

Save to ▾
Show answer
SELECT customer_id, SUM(amount) AS revenue FROM orders GROUP BY customer_id ORDER BY revenue DESC LIMIT 5;
22

What is a KPI tree?

Save to ▾
Show answer
It breaks a top metric into drivers: Revenue = Users × Conversion × AOV; Users = New + Returning, and so on. It shows which lever to pull and where a drop came from.
23

Write a SQL query to calculate the DAU to MAU stickiness ratio for a month.

Save to ▾
Show answer
WITH daily AS ( SELECT event_date, COUNT(DISTINCT user_id) AS dau FROM events WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01' GROUP BY event_date ), monthly AS ( SELECT COUNT(DISTINCT user_id) AS mau FROM events WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01' ) SELECT ROUND(AVG(d.dau) * 1.0 / MAX(m.mau), 3) AS stickiness FROM daily d CROSS JOIN monthly m;
24

What is the difference between ROI, ROE and ROCE?

Save to ▾
Show answer
ROI (return on investment) is the gain from a specific investment divided by its cost and is used to judge projects or campaigns. ROE (return on equity) is net profit divided by shareholders' equity and shows the return to owners; high debt can inflate it. ROCE (return on capital employed) is EBIT divided by equity plus long-term debt and shows how efficiently all long-term capital is used. ROCE is better for comparing companies with different debt levels.
25

Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?

Save to ▾
Show answer
Break the change into drivers. Price: were discounts or promotions deeper? Mix: did sales shift towards lower-margin products, channels or regions? Cost: did raw material, freight or supplier prices rise, or did currency movements raise import costs? Also check one-offs like inventory write-offs and accounting reclassifications. Build a margin bridge showing how many percentage points each driver contributed, then take the biggest driver to the business owner with a specific action.
26

Write DAX measures for Total Sales, Sales Last Year and Year-over-Year growth percent.

Save to ▾
Show answer
Total Sales = SUM(Sales[Amount]) Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) YoY % = DIVIDE([Total Sales] - [Sales LY], [Sales LY]) -- needs a marked date table; DIVIDE avoids divide-by-zero errors
27

Write an Excel formula for month-to-date sales up to today.

Save to ▾
Show answer
// Dates in Sales[Date], amounts in Sales[Amount] =SUMIFS(Sales[Amount], Sales[Date], ">=" & EOMONTH(TODAY(), -1) + 1, Sales[Date], "<=" & TODAY()) // EOMONTH(TODAY(),-1)+1 gives the first day of the current month
28

What are LOD expressions in Tableau and how do FIXED, INCLUDE and EXCLUDE differ?

Save to ▾
Show answer
Level of Detail expressions compute an aggregate at a granularity different from the view. FIXED computes at the stated dimensions regardless of the view, for example { FIXED [Customer ID] : MIN([Order Date]) } for first purchase date. INCLUDE adds a dimension to the view level, useful for average sales per customer by region. EXCLUDE removes a dimension, useful for comparing each month with the yearly total. FIXED ignores normal dimension filters unless they are context filters.
29

A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?

Save to ▾
Show answer
Demand: population density, smartphone and digital payment penetration, average basket size and how often people buy groceries. Supply: dark store rent, rider availability and local sourcing. Unit economics: orders per store per day needed to break even, given lower average order values. Competition: local kirana delivery and other apps. Then propose a pilot in two or three cities with clear success metrics such as orders per day, contribution margin per order and repeat rate before scaling.
30

Your monthly Excel report takes a full day of manual work. How would you automate it?

Save to ▾
Show answer
Map the steps first: which files arrive, what cleaning is done and which outputs are needed. Move the import and cleaning into Power Query so a refresh replaces copy-paste. Base calculations on Excel Tables and PivotTables that update automatically, and keep a fixed template for the output. Use a small macro or Office Script only for the remaining formatting or emailing. Add checks such as row counts and totals so errors surface quickly.
31

What is the difference between ROW_NUMBER, RANK and DENSE_RANK?

Save to ▾
Show answer
All three number rows within a window ordered by a column. ROW_NUMBER gives a unique sequence 1, 2, 3 even for ties. RANK gives ties the same number and then skips, so 1, 1, 3. DENSE_RANK gives ties the same number without gaps, so 1, 1, 2. Use ROW_NUMBER to pick exactly one row per group, such as the latest order, and DENSE_RANK for 'top 3 distinct salary levels' type questions.
32

A critical defect is found on the last day of UAT, and the go-live date cannot move. What do you do?

Save to ▾
Show answer
Confirm the impact and reproduce it quickly. Work with development to estimate a fix and its regression effort. Then present options to the business owner with risks: fix and do targeted retesting before go-live, go live with a temporary workaround or manual process, go live with the affected feature switched off, or delay. The decision belongs to the business, documented at the go or no-go meeting. Never hide a critical defect to protect a date.
33

Write a SQL query to get each customer's first order date and first order amount.

Save to ▾
Show answer
WITH ordered AS ( SELECT customer_id, order_date, amount, ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date, order_id) AS rn FROM orders ) SELECT customer_id, order_date AS first_order_date, amount AS first_order_amount FROM ordered WHERE rn = 1;
34

What are dynamic array functions in Excel and how do they help analysts?

Save to ▾
Show answer
Dynamic array functions return several values that spill into neighbouring cells. UNIQUE lists distinct values, SORT and SORTBY order data, FILTER returns rows meeting conditions, SEQUENCE builds number series, and XLOOKUP can return whole rows. For example =SORT(UNIQUE(FILTER(Sales[Region], Sales[Year]=2026))) builds a live region list. They replace many helper columns and Ctrl+Shift+Enter array formulas, and the # operator references a full spill range.
35

Monthly subscription churn jumped from 3 percent to 5 percent. How do you investigate?

Save to ▾
Show answer
Confirm the data first: definition changes, failed-payment handling or a billing date shift. Then segment churn by plan, tenure, acquisition channel, city and device to find where it concentrates. Separate voluntary cancellations from involuntary card failures. Look at events before the jump, like a price change, app release or competitor offer, and read cancellation reasons. Recommend targeted fixes, such as payment retries or win-back offers, and track the affected cohort.
36

What steps do you follow to plan and run a UAT cycle?

Save to ▾
Show answer
Plan: agree scope, entry and exit criteria, testers and schedule with the business owner. Prepare: write scenarios and test cases from requirements, set up the environment and test data, and brief testers. Execute: run test cases in daily sessions, log defects with evidence and hold a daily triage. Monitor: report progress, pass rate and open defects by severity. Close: check exit criteria, get the business sign-off with known issues documented, and hold a short lessons-learned review.
37

How do you estimate the annual revenue of a coffee shop chain?

Save to ▾
Show answer
Number of outlets x daily customers x average bill x operating days, then validate using footfall, peak hours and similar chains.
38

A stakeholder's only requirement is 'make the app faster'. How do you turn this into clear requirements?

Save to ▾
Show answer
Ask which screens or actions feel slow, for which users, on which devices and networks, and how it affects the business, such as checkout drop-off. Gather current timings from monitoring data. Then write measurable non-functional requirements, for example 'the search results page loads within 2 seconds for 95 percent of requests on a 4G connection'. Confirm targets with the stakeholder and agree how they will be tested.
39

What is the logical order in which a SQL SELECT query is executed?

Save to ▾
Show answer
Logically the database processes FROM and JOIN first, then WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY and finally LIMIT or TOP. This explains common errors: you cannot use a SELECT alias in WHERE because WHERE runs earlier, aggregate conditions must go in HAVING, and window functions cannot be filtered in WHERE, so you wrap them in a CTE or subquery. The optimiser may physically reorder steps, but the result follows this order.
40

Finance asks you to build a monthly cohort retention table in Excel from raw order data. How do you approach it?

Save to ▾
Show answer
Add a helper column for each customer's first order month using MINIFS on customer ID, and another for the order month. Compute the month index as the difference in months between them. Then build a PivotTable or COUNTIFS grid with cohort month as rows, month index as columns and distinct customers as values. Divide each cell by the month-zero count to get retention percentages and add a colour scale to show decay.

Tips to crack the Oracle Business Analytics interview

  • Revise SQL and PL/SQL deeply, including joins, indexes, transactions and query optimisation, as databases are central to Oracle.
  • Read basic OCI concepts like compute, storage and autonomous database if you are interviewing for cloud teams.
  • Practise explaining DBMS, operating systems and networking fundamentals, which are often tested in Oracle technical rounds.
  • Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
  • Practise the hard questions on this page aloud; Oracle interviewers usually ask follow-ups on your first answer.

Frequently asked questions

How many rounds are there in the Oracle Business Analytics interview?

Candidates usually go through 5 stages: Online assessment (aptitude + coding + CS MCQs); Technical round 1; Technical round 2; Managerial round; HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.

Which topics should I prepare for the Oracle Business Analytics interview?

This practice set leans on Excel for Business Analysts (7), Financial and Business Analysis (6), Business Metrics and KPIs (5), SQL for Business Analysis (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Oracle interviewers ask you to walk through real work.

Are these the exact questions asked at Oracle?

No. These are curated practice questions that match the skills and difficulty usually tested in product interviews like Oracle's. They are not a leaked or verified list of past questions.

Where does Oracle hire Business Analytics professionals in India?

Oracle has large teams in Bengaluru, Hyderabad, Noida, Mumbai, Pune. Openings and locations change often, so check the Oracle careers page and filter by city and experience.

Business Analytics questions for similar companies