i
Oak Tree Software
Filter interviews by
Be the first one to contribute and help others!
posted on 17 Dec 2024
I applied via Instahyre and was interviewed in Nov 2024. There was 1 interview round.
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
Write a SQL query to count number of reportees for each manager using GROUP BY clause
Add HAVING clause to filter out managers with atleast 5 reportees
Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
Use libraries like pandas and dask to efficiently manage large datasets in Python.
Use pandas library for data manipulation and analysis.
Use dask library for parallel computing and out-of-core processing.
Optimize memory usage by loading data in chunks or using data types efficiently.
Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
Pandas - used for data manipulation and analysis
NumPy - used for numerical computing and working with arrays
Matplotlib - used for data visualization
Scikit-learn - used for machine learning and data mining
I applied via Company Website and was interviewed in Dec 2024. There were 2 interview rounds.
A session in PHP is a way to store information (variables) to be used across multiple pages.
Sessions are used to store user data on the server for later use
Sessions are identified by a unique session ID, usually stored in a cookie
Session data is stored on the server side, making it more secure than using cookies alone
Variables can be changed during the execution of a script, while constants cannot be changed once they are defined.
Variables can be reassigned with new values, while constants cannot be changed once defined
Constants are defined using the define() function, while variables are assigned using the $ symbol
Constants are case-sensitive by default, while variables are case-insensitive
The code will output 'Hello World!' because the variable $x is set to true.
The code will check if $x is true, which it is, so it will output 'Hello World!'
The if statement will only execute if the condition is true, in this case $x is true.
What are the differences between echo and print in PHP?
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
Linux commands are used to interact with the operating system and perform various tasks.
ls - list directory contents
cd - change directory
pwd - print working directory
mkdir - make directory
rm - remove files or directories
cp - copy files or directories
mv - move files or directories
grep - search for patterns in files
chmod - change file permissions
sudo - execute a command as a superuser
List is mutable, tuple is immutable in Python.
List can be modified after creation, tuple cannot.
List uses square brackets [], tuple uses parentheses ().
List is used for collections of items that may change, tuple for fixed collections.
Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
UCAT exam - 40 question - 20min
posted on 6 Jan 2025
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
Easy you will have enough time to solve the questions
posted on 8 Jan 2025
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
Segregate odd and even numbers in an integer array without using another array
Iterate through the array and maintain two pointers, one for odd numbers and one for even numbers
Swap elements at the odd and even pointers until all odd numbers are on one side and even numbers on the other
Example: Input array [3, 6, 8, 5, 4], Output array [6, 8, 4, 5, 3]
posted on 7 Oct 2024
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
To reverse a string and find the occurrence of a character in Java.
Use StringBuilder to reverse the string.
Use a loop to iterate through the string and count the occurrences of the character.
Use the charAt() method to access individual characters in the string.
To take a screenshot in Selenium, use the getScreenshotAs method
Create a WebDriver instance
Use the getScreenshotAs method to capture the screenshot
Save the screenshot to a file using File class
Getter and setter methods are used to access and modify the values of private variables in a class.
Create a method with the prefix 'get' followed by the variable name to retrieve its value.
Create a method with the prefix 'set' followed by the variable name to set its value.
Ensure the getter method returns the value of the variable and the setter method updates the variable with the passed value.
Object-oriented programming paradigm and its four pillars: Inheritance, Encapsulation, Abstraction, Polymorphism
Inheritance: Allows a class to inherit properties and behavior from another class
Encapsulation: Bundling data and methods that operate on the data into a single unit
Abstraction: Hiding the complex implementation details and showing only the necessary features
Polymorphism: Ability to present the same interface
posted on 20 Dec 2024
I applied via Walk-in and was interviewed in Nov 2024. There were 4 interview rounds.
Hardware & networking
All software update update
The questions are quite simple.
Two SQL and two Python HackerRank questions.
Questions were asked about the projects listed on my resume, focusing on the technologies used, challenges faced, and results achieved.
Technologies used in the project
Challenges faced during the project
Results achieved from the project
I applied via Naukri.com and was interviewed in May 2024. There were 3 interview rounds.
I applied via Campus Placement
Dsa problems dp and tress problem
I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.
5 years of experience in software development
Proficient in developing web applications
Skilled in using various technologies
Passionate about software engineering
based on 7 reviews
Rating in categories
Salesforce Developer
33
salaries
| ₹3 L/yr - ₹10.4 L/yr |
Software Developer
8
salaries
| ₹1.8 L/yr - ₹7.5 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 |
ROR Developer
5
salaries
| ₹2 L/yr - ₹6 L/yr |
TCS
Infosys
Wipro
HCLTech