AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Oak Tree Software
Compare
Filter interviews by
Oak Tree Software Interview Questions and Answers
Oak Tree Software Interview Experiences
1 interview found
Anonymous
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. After an initial round with HR and a technical interview, I was given an assessment to complete which was fairly complex, took me 20 hours to complete. After I submitted the assignment, the QA team was con...
- Q2. Don't fall for the trap
Top trending discussions
Interview questions from similar companies
Selected
I applied via Campus Placement and was interviewed in Oct 2022. There were 6 interview rounds.
Easy to crack the test
Somewhat ok need to be a bit fluent
They gave us portal with bugs we have to find them.
(1 Question)
- Q1. Some random logical thinking questions
(1 Question)
- Q1. Tell me abt yourself
- Ans.
I am a motivated and enthusiastic individual with a strong passion for learning and gaining practical experience in the field of [field].
I have recently completed my [degree/qualification] in [field] from [university/institution].
During my studies, I gained hands-on experience through internships at [company/organization] where I worked on [specific projects/tasks].
I have a solid understanding of [relevant skills/techn...
Interview Preparation Tips
Selected
I appeared for an interview before Jun 2024, where I was asked the following questions.
- Q1. LLD one question Parking lot system
- Q2. Queue related basic questions
- Q3. Basic .net core questions
Good 10 questions aptitude test
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
6 mcqs and 2 sql questions
(5 Questions)
- Q1. Difference between having and where in sql
- Q2. Sql joins and it types
- Q3. Window functions and subqueries
- Q4. Sql scenario question based on joins
- Q5. Kpi's and metrics
(1 Question)
- Q1. Business problem related to case study
Interview Preparation Tips
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.
Basic Hacker Rank SQL Questions 2 . and 10 MCQ based
(3 Questions)
- Q1. Select customer, sum(amt ) as total_amt from t1 group by customer how many no. of rows it will return and explain this table t1 column name-> dept customer item amt
- Q2. Select * , sum(amt) over (partition by customer) as total_amt from t2
- Ans.
The query selects all columns and calculates the total amount for each customer in table t2.
The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.
The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.
The 'select *' statement selects all columns from the table along with the calculated total amount.
The 'sum(amt) over (partiti...
- Q3. How many Customers has purchased same item on the Same day more than onnce
- Ans.
To find customers who purchased the same item multiple times on the same day.
Identify unique customers who purchased the same item multiple times on the same day
Check for duplicate transactions by customer and item on the same day
Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day
Interview Preparation Tips
Selected
I appeared for an interview before May 2024, where I was asked the following questions.
- Q1. Normal sales questions with little bit maths percentage question
- Q2. Profit loss, percentage question must be prepared
Interview Preparation Tips
Anukul Kumar
(1 Question)
- Q1. JavaScript based, reduce, map, Database indexing
I applied via Naukri.com and was interviewed before Nov 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Experience and confidence
- Q2. Industry knowledge ,b2b experience or software sales experience
Interview Preparation Tips
Selected
I applied via Walk-in and was interviewed in Sep 2023. There were 3 interview rounds.
(1 Question)
- Q1. Self introduction
(1 Question)
- Q1. Discuss about Experience
Interview Preparation Tips
Oak Tree Software Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
Oak Tree Software Reviews and Ratings
based on 12 reviews
Rating in categories
|
Salesforce Developer
32
salaries
|  ₹3 L/yr - ₹10.4 L/yr |
|
Software Developer
8
salaries
| ₹1.8 L/yr - ₹7.5 L/yr |
|
Software Engineer
5
salaries
| ₹3.8 L/yr - ₹12 L/yr |
|
Business Development Executive
5
salaries
| ₹2.2 L/yr - ₹5.4 L/yr |
|
Senior Software Developer
5
salaries
| ₹6.5 L/yr - ₹16.5 L/yr |
Vyapar
Tata nexarc
Classplus
Fleetx.io
- Home >
- Interviews >
- Oak Tree Software Interview Questions
