i
NITS SOLUTIONS
Filter interviews by
I applied via LinkedIn and was interviewed before Apr 2023. There were 2 interview rounds.
Union combines and removes duplicates, Union All combines without removing duplicates.
Union combines two or more result sets and removes duplicates
Union All combines two or more result sets without removing duplicates
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2
Rank is the position of a data point in a list, while dens rank is the average of the ranks of tied values.
Rank is the position of a data point when the data is sorted in ascending or descending order.
Dens rank is used when there are tied values, it assigns the average rank to each tied value.
For example, if we have values 5, 7, 7, 9, the rank of 7 would be (2+3)/2 = 2.5.
Top trending discussions
I applied via Approached by Company and was interviewed before Jul 2023. There was 1 interview round.
MCQ, SQL Programming round --> 1 question , Python programming round --> 1 question, Data Science programming round --> 2 questions
I applied via Approached by Company and was interviewed in Aug 2024. There were 3 interview rounds.
AB testing is a method used to compare two versions of a webpage or app to determine which one performs better.
AB testing involves creating two versions (A and B) of a webpage or app with one differing element
Users are randomly assigned to either version A or B to measure performance metrics
The version that performs better in terms of the desired outcome is selected for implementation
Example: Testing two different call...
It was a classification problem
I applied via Company Website and was interviewed before May 2020. There were 3 interview rounds.
I applied via Company Website and was interviewed in Jul 2022. There were 3 interview rounds.
Case Study interview
Puzzle
Live Coding
Case study interview
I applied via Referral and was interviewed in Mar 2024. There was 1 interview round.
I applied via Recruitment Consulltant and was interviewed before Jun 2023. There were 2 interview rounds.
I was given assigment on a simple problem where task was to analyse and create a working solution for a problem statement
BERT (Bidirectional Encoder Representations from Transformers) is a pre-trained natural language processing model.
BERT is a transformer-based machine learning algorithm developed by Google.
It is designed to understand the context of words in a sentence by considering both the left and right context simultaneously.
BERT has been pre-trained on a large corpus of text data and can be fine-tuned for specific NLP tasks like ...
Logistic regression is a type of regression analysis used to predict the probability of a binary outcome.
Logistic regression is used when the dependent variable is binary (e.g. 0 or 1, yes or no).
It estimates the probability that a given input belongs to a certain category.
The output of logistic regression is transformed using a sigmoid function to ensure it falls between 0 and 1.
It uses the logistic function to model ...
R-squared value is a statistical measure that represents the proportion of the variance in the dependent variable that is predictable from the independent variable(s).
R-squared value ranges from 0 to 1, with 1 indicating a perfect fit.
It is used to evaluate the goodness of fit of a regression model.
A higher R-squared value indicates that the model explains a larger proportion of the variance in the dependent variable.
F...
Python , pandas, sql
Interview experience
Business Analyst
36
salaries
| ₹3.6 L/yr - ₹12.3 L/yr |
Associate Software Engineer
17
salaries
| ₹3.5 L/yr - ₹8.6 L/yr |
Data Analyst
17
salaries
| ₹3 L/yr - ₹8.3 L/yr |
Telecaller
11
salaries
| ₹1 L/yr - ₹2.2 L/yr |
Senior Quality Analyst
9
salaries
| ₹8.8 L/yr - ₹12 L/yr |
TCS
Infosys
Wipro
HCLTech