Question 1

SQL Regular Expression

Question

Get all employee detail from EmployeeDetail table whose "FirstName" not start with any single character between 'a-p'

solved 1

SQL 55 years 5 Answers 2172 views Grand Master

Question 2

SQL interview question | Conditional Query

Question

Write an SQL Query find number of employees according to gender whose DOB is between 01/01/1960 to 31/12/1975. Use column name as sex,DOB table name Employees

in progress 1

SQL 55 years 6 Answers 2636 views Grand Master

Question 3

100 Interview Questions

Question

Web Analytics

2

R 55 years 0 Answers 979 views Grand Master

Question 4

How does the value of R squared and adjusted R Squared error change when you add new variable in your model?

Question

How?

in progress 0

Machine Learning 55 years 8 Answers 2201 views Grand Master

Question 5

What is better ? A low R squared or a high R squared?

Question

R squared error

solved 0

Machine Learning 55 years 6 Answers 1741 views Grand Master

Question 6

What is the acceptable value range for p,d and q in ARIMA?

Question

Why we can’t have large value for d?

in progress 3

Machine Learning 55 years 1 Answer 1523 views Grand Master

Question 7

Explain Long Short Term Memory Algorithm in brief

Question

With code snippet in R or Python

in progress 0

Machine Learning 55 years 1 Answer 1044 views Grand Master

Question 8

Explain Holt winters in brief.

Question

Please provide code snippet

in progress 0

Machine Learning 55 years 4 Answers 1439 views Grand Master

Question 9

What is SARIMA and how is it different from ARIMA?

Question

Seasonal ARIMA

solved 0

Machine Learning 55 years 1 Answer 951 views Grand Master

Question 10

How is ARIMAX different from ARIMA?

Question

What does X stands for ?

in progress 0

Machine Learning 55 years 1 Answer 1402 views Grand Master

Question 11

How to get the value of d in p,d,q in ARIMA?

Question

ARIMA model

in progress 0

Machine Learning 55 years 1 Answer 1038 views Grand Master

Question 12

How to read PACF graph?

Question

Partial auto correlation factor

in progress 0

Machine Learning 55 years 2 Answers 1479 views Grand Master

Question 13

How to read ACF graph ? What is lag in ACF graph?

Question

Auto correlation factor

in progress 0

Machine Learning 55 years 1 Answer 1564 views Grand Master

Question 14

How to forecast number of Pizza which will be sold in Pizza Hut in next week?

Question

Assume things but come up with an approach :)

in progress 0

Case Study 55 years 2 Answers 1656 views Grand Master

Question 15

Write sample code of ARIMA in Python or R

Question

Just the main part of the code

in progress 0

Machine Learning 55 years 3 Answers 983 views Grand Master

Question 16

What is Degree of Freedom in ARIMA?

Question

Explain with example

solved 0

Machine Learning 55 years 3 Answers 1769 views Grand Master

Question 17

What is BIC in ARIMA model?

Question

With exaple

in progress 0

Machine Learning 55 years 2 Answers 1352 views Grand Master

Question 18

Define ARIMA in simplest terms

Question

With example

solved 0

Machine Learning 55 years 4 Answers 1213 views Grand Master

Question 19

What is AIC in arima?

Question

Explain

solved 0

Machine Learning 55 years 3 Answers 2559 views Grand Master

Question 20

What is ADF test in time series analysis ?

Question

What is the output of ADF test

in progress 0

Machine Learning 55 years 4 Answers 1488 views Grand Master

Question 21

Difference between cyclicity and seasonality

Question

Explain

in progress 1

Machine Learning 55 years 3 Answers 4929 views Grand Master

Question 22

Explain seasonality ?

Question

With example

in progress 0

Machine Learning 55 years 3 Answers 1065 views Grand Master

Question 23

Explain the trend in forecasting

Question

With example

in progress 0

Machine Learning 55 years 3 Answers 1223 views Grand Master

Question 24

What is worse, type 1 error or type 2 error?

Question

Errors in machine learning

in progress 0

Statistics 55 years 11 Answers 2318 views Grand Master

Question 25

Explain type 2 error in simple terms

Question

Confusion matrix

in progress 0

Statistics 55 years 13 Answers 1736 views Grand Master

Question 26

Explain type 1 error in simplest terms

Question

confusion matrix

solved 0

Statistics 55 years 14 Answers 1969 views Grand Master

Question 27

You have created a model for fire alarm, explain confusion matrix with this example

Question

Example of confusion matrix

solved 0

Statistics 55 years 7 Answers 1674 views Grand Master

Question 28

Explain recall in simple terms

Question

with respect to confusion matrix

in progress 0

Statistics 55 years 8 Answers 1856 views Grand Master

Question 29

Explain precision in the simplest terms

Question

with respect to confusion matrix

solved 1

Statistics 55 years 8 Answers 1398 views Grand Master

Question 30

When to use Linear and when yo use Logistic regression?

Question

Classification and regression

solved 0

Machine Learning 55 years 8 Answers 1829 views Grand Master

Question 31

Explain decision tree in simple terms

Question

What is a decision tree?

solved 0

Machine Learning 55 years 6 Answers 2404 views Grand Master

Question 32

What are the methods to choose the value of K in k-means algorithm?

Question

There are I guess at least 2 methods

in progress 1

Statistics 55 years 7 Answers 3306 views Grand Master

Question 33

How to select number of trees in Random forest?

Question

Trees and RF

solved 1

Machine Learning 55 years 7 Answers 1433 views Grand Master

Question 34

What are the different regression algorithm?

Question

Name at least 3

solved 0

Machine Learning 55 years 3 Answers 1443 views Grand Master

Question 35

What are the metrics to measure the performance of your Linear Regression model? Most asked question

Question

Almost all the interviewer asks this question

solved 0

Statistics 55 years 12 Answers 4611 views Grand Master

Question 36

Define R squared error in simple terms

Question

Try not to use a lot of mathematics

in progress 0

Statistics 55 years 12 Answers 2121 views Grand Master

Question 37

What is the need to remove multicolinearity ?

Question

What would happen if we don’t remove it?

solved 0

Statistics 55 years 11 Answers 2099 views Grand Master

Question 38

Define Loss function in the simplest way possible

Question

Where is it used ?

in progress 0

Statistics 55 years 12 Answers 1854 views Grand Master

Question 39

What is the best fit line in Linear Regression?

Question

Explain best fit line to define the problem

solved 0

Statistics 55 years 10 Answers 6787 views Grand Master

Question 40

What makes Ridge Regression different from Linear Regression?

Question

Explain in simple terms

solved 0

Machine Learning 55 years 8 Answers 2103 views Grand Master

Question 41

Define ROC in layman terms

Question

Also explain where is it used

in progress 0

Statistics 55 years 10 Answers 2323 views Grand Master

Question 42

Difference in formula between sample and population variance?

Question

Explain the difference with example

solved 1

Statistics 55 years 10 Answers 7107 views Grand Master

Question 43

What us the difference between chi-square, z-test, and t-test

Question

No numerical answer, only conceptual answer expected

in progress 2

Statistics 55 years 6 Answers 3474 views Grand Master

Question 44

Which test to use when you have less than 30 sampling units? Amazon online interview question

Question

Explain the reason

solved 0

Statistics 55 years 10 Answers 1859 views Grand Master

Question 45

SQL output question | The Moonfrog Lab interview question

Question

SELECT ‘NITIN’+1 SELECT ‘NITIN’+’1’ SELECT(SELECT ‘NITIN’) SELECT ‘1’+1 SELECT 1+’1’

solved 3

SQL 55 years 18 Answers 2511 views Grand Master

Question 46

Can you join two table without any common column?

Question

Join interview question

in progress 3

SQL 55 years 17 Answers 3186 views Grand Master

Question 47

You always have a big data i.e. millions of rows in your tables, how would you partition it for optimum performance?

Question

Give a couple of partitioning examples

in progress 2

SQL 55 years 9 Answers 2258 views Grand Master

Question 48

What is indexing in SQL? Meredith India interview question

Question

Explain with proper example

in progress 2

SQL 55 years 12 Answers 2783 views Grand Master

Question 49

What is the difference between COUNT(*) and COUNT(ColName)?

Question

Explain with any example code

solved 1

SQL 55 years 14 Answers 2311 views Grand Master

Question 50

What is the use of FETCH command? OLA interview question

Question

With code snippet

in progress 1

SQL 55 years 10 Answers 1981 views Grand Master

Register Now

Login

Lost Password

Welcome to The Data Monk