Oracle Interview Questions

Oracle Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(81)
SQL
(58)
Machine Learning
(50)
Probability
(30)
Statistics
(20)

Oracle Interview Questions

Practice for the Oracle interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

We’re given a table of product purchases. Each row in the table represents an individual user product purchase.

Write a query to get the number of customers that were upsold, or in other words, the number of users who bought additional products after their first purchase.

Note: If the customer purchased two things on the same day, that does not count as an upsell, as they were purchased within a similar timeframe.

Example:

Input:

transactions table

Column Type
id INTEGER
user_id INTEGER
created_at DATETIME
product_id INTEGER
quantity INTEGER

Output:

Column Type
num_of_upsold_customers INTEGER
Data Structures & Algorithms
Easy
Machine Learning
Easy
Loading pricing options

View all Oracle questions

Challenge

Check your skills...
How prepared are you for working at Oracle?

Oracle Salaries by Position

Business Intelligence*
$211K
$220K
Business Intelligence
Median: $215K
Mean (Average): $215K
Data points: 2
Data Analyst*
$104K
$223K
Data Analyst
Median: $164K
Mean (Average): $164K
Data points: 2
$67K
$225K
Software Engineer
Median: $144K
Mean (Average): $150K
Data points: 861
$83K
$220K
Product Manager
Median: $145K
Mean (Average): $148K
Data points: 133
$61K
$197K
Data Engineer
Median: $147K
Mean (Average): $143K
Data points: 14
AI Research Scientist*
$135K
AI Research Scientist
Median: $135K
Mean (Average): $135K
Data points: 1
$97K
$177K
ML Engineer
Median: $130K
Mean (Average): $129K
Data points: 11
$74K
$174K
Data Scientist
Median: $119K
Mean (Average): $123K
Data points: 145
$79K
$140K
Marketing Analyst
Median: $106K
Mean (Average): $108K
Data points: 4
$74K
$136K
Business Analyst
Median: $105K
Mean (Average): $106K
Data points: 18

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Business Intelligence role pays the most with a $215,000 base salary while the Business Analyst role on average pays the least with a $106,284 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.