Practice for the Oracle interview with these recently asked interview questions.
| Question | Topic | Difficulty | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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:
Output:
| ||||||||||||||||||
Data Structures & Algorithms | Easy | |||||||||||||||||
Machine Learning | Easy | |||||||||||||||||
SQL | Easy | |
Machine Learning | Medium | |
Statistics | Medium | |
SQL | Hard | |
Machine Learning | Medium | |
Python | Easy | |
Deep Learning | Hard | |
SQL | Medium | |
Statistics | Easy | |
Machine Learning | Hard |
Check your skills...
How prepared are you for working at Oracle?
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