AI Variant Interview Questions and Answers

Q1. Stats ML Supervised Unsupervised
Add your answer
Q2. What is central limit theorem
Ans. 
Central Limit Theorem states that the sampling distribution of the sample mean approaches a normal distribution as the sample size increases.
• The theorem states that regardless of the shape of the population distribution, the sampling distribution of the sample mean will be approximately normally distributed.

• It is a fundamental concept in statistics and is used in hypothesis testing and confidence intervals.

• For example,...read more
Answered by AI
Add your answer

Q1. How did you handle clients
Add your answer

Q1. Advanced Excel ques
Add your answer

Aptitude test was good and well organised

Coding test consists of SQL queries, Excel, python questions

The assignment was basic and bit tricky

Q1. How would you remove duplicates In mysql
Ans. 
To remove duplicates in MySQL, you can use the DISTINCT keyword or the GROUP BY clause.
• Use the DISTINCT keyword to select unique values from a single column.

• Use the GROUP BY clause to select unique combinations of values from multiple columns.

• You can also use the DELETE statement with a subquery to remove duplicate rows from a table.
Answered by AI
Add your answer
Q2. How to find last 3 records
Ans. 
To find the last 3 records, sort the data in descending order and select the first 3 records.
• Sort the data in descending order based on the relevant field

• Select the first 3 records from the sorted data
Answered by AI
Add your answer

Data Science , machine learning, python

Coding on python, mysql, r