i
Affine
Filter interviews by
Clear (1)
I applied via Approached by Company
Joining tables with different joins in SQL
Use INNER JOIN to return rows when there is at least one match in both tables
Use LEFT JOIN to return all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table
Use FULL JOIN to return rows when there is a match in one of the tables
Top trending discussions
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
The Aptitude round was of mediocre level, get well prepared for it and it is a qualifying round
I was interviewed in Aug 2023.
Logical, statistics, Aptitude, Data science and analytics
Delete removes specific rows from a table, while Truncate removes all rows from a table.
Delete is a DML command, while Truncate is a DDL command.
Delete can be rolled back, while Truncate cannot be rolled back.
Delete maintains the table structure and indexes, while Truncate resets the table structure and indexes.
Delete triggers delete triggers and delete constraints, while Truncate does not trigger any triggers or const...
Assumptions of regression
Linearity: The relationship between the independent and dependent variables is linear.
Independence: The residuals are independent of each other.
Homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.
Normality: The residuals are normally distributed.
No multicollinearity: The independent variables are not highly correlated with each other.
I applied via Approached by Company and was interviewed before Feb 2023. There were 2 interview rounds.
General aptitude test on an online platform with camera and mic monitoring.
I applied via Company Website and was interviewed in Dec 2023. There were 2 interview rounds.
Ridge and lasso regression are both regularization techniques used in linear regression to prevent overfitting by adding penalty terms to the cost function.
Ridge regression adds a penalty term equivalent to the square of the magnitude of coefficients, while lasso regression adds a penalty term equivalent to the absolute value of the magnitude of coefficients.
Ridge regression tends to shrink the coefficients towards zer...
Random forest is an ensemble method using multiple decision trees, XGBoost is a gradient boosting algorithm that builds trees sequentially.
Random forest is an ensemble learning method that builds multiple decision trees and combines their predictions.
Decision tree is a single tree model that makes decisions based on features to predict outcomes.
XGBoost is a gradient boosting algorithm that builds trees sequentially, op...
I was interviewed in Jun 2024.
I applied via Job Fair and was interviewed before Feb 2021. There was 1 interview round.
I can code a program in Python and Java.
I am proficient in both Python and Java programming languages.
I have experience in developing web applications using Python and Java frameworks.
I can write efficient and optimized code in both languages.
I can develop programs for data analysis, machine learning, and automation using Python.
I can develop enterprise-level applications using Java.
Examples: Python - a program to scra...
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
I applied via Referral and was interviewed in Jan 2023. There were 5 interview rounds.
Simple test with basic questions and reasoning.
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Senior Associate
129
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
94
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Business Analyst
87
salaries
| ₹0 L/yr - ₹0 L/yr |
Consultant
87
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Engineer
47
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics