Tredence
10+ Aditya Engineering Services Interview Questions and Answers
Q1. Puzzle: Given two hour glass, one measuring 4 mins and the other 7 mins, how to measure 9 mins
To measure 9 minutes using two hourglasses of 4 and 7 minutes, start both hourglasses simultaneously. When the 4-minute hourglass runs out, flip it again. When the 7-minute hourglass runs out, flip it again. When the 4-minute hourglass runs out for the third time, 9 minutes will have passed.
Start both hourglasses simultaneously
When the 4-minute hourglass runs out, flip it again
When the 7-minute hourglass runs out, flip it again
When the 4-minute hourglass runs out for the thir...read more
Q2. How you reduce error in model Which kind of matrix used in your model How you map data
To reduce error in a model, I use techniques like cross-validation, regularization, and feature selection. I use matrices like confusion matrix and correlation matrix. Data is mapped using techniques like normalization and encoding.
Reduce error in model by using techniques like cross-validation, regularization, and feature selection
Use matrices like confusion matrix to evaluate classification models and correlation matrix to analyze relationships between variables
Map data usi...read more
Q3. What are different optimisation techniques you have used so far in databricks
I have used techniques like hyperparameter tuning, feature engineering, and model selection in Databricks for optimization.
Hyperparameter tuning using GridSearchCV or RandomizedSearchCV
Feature engineering to create new features or transform existing ones
Model selection using techniques like cross-validation or ensemble methods
Q4. Rate yourself in sql and python
I rate myself highly in SQL and Python.
I have extensive experience in writing complex SQL queries and optimizing database performance.
I am proficient in Python and have used it for data analysis, automation, and web scraping.
I have worked on various projects where I utilized both SQL and Python together to extract, transform, and load data.
I am familiar with popular SQL databases like MySQL, PostgreSQL, and Oracle, as well as Python libraries like pandas and SQLAlchemy.
Aptitude questions related to speed, time and distance, work done, ratio and proportions, probability etc.
Number Of MCQs - 30
Hourglass puzzle
Q7. Draw Box-plot and explain its characteristics
Box-plot is a visual representation of the distribution of a dataset, showing the median, quartiles, and outliers.
Box-plot displays the median (middle line), quartiles (box), and outliers (dots or lines).
The length of the box represents the interquartile range (IQR).
Whiskers extend to the smallest and largest non-outlier data points within 1.5 times the IQR from the quartiles.
Outliers are plotted individually as dots or lines beyond the whiskers.
Box-plots are useful for compa...read more
Q8. how to handle outliars
Outliers can be handled by identifying, analyzing, and either removing or transforming them in the data.
Identify outliers using statistical methods like Z-score or IQR.
Analyze the outliers to understand if they are errors or valid data points.
Remove outliers if they are errors or transform them using techniques like winsorization or log transformation.
Consider using robust statistical methods that are less sensitive to outliers.
Visualize the data to identify outliers visually...read more
Q9. standardisation vs normalisation
Standardisation and normalisation are techniques used to scale and transform data in order to improve model performance.
Standardisation (Z-score normalisation) scales the data to have a mean of 0 and a standard deviation of 1.
Normalisation (Min-Max scaling) scales the data to a specific range, typically between 0 and 1.
Standardisation is less affected by outliers compared to normalisation.
Standardisation is preferred when the data follows a normal distribution, while normalis...read more
Q10. what is deadlocks?
Deadlocks occur when two or more processes are unable to proceed because each is waiting for the other to release a resource.
Deadlocks happen in multitasking environments where processes compete for resources.
Four conditions must hold for a deadlock to occur: mutual exclusion, hold and wait, no preemption, and circular wait.
Example: Process A holds Resource 1 and waits for Resource 2, while Process B holds Resource 2 and waits for Resource 1.
Deadlocks can be prevented or reso...read more
Top HR Questions asked in Aditya Engineering Services
Interview Process at Aditya Engineering Services
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month