Question 1

Count of duplicate rows in SQL

Question

I have a table student with only one column i.e. Roll No. The values in the table are 10 20 10 10 20 There are in total 3 repetitive values i.e. 10 is repeated two extra times and 20 is repeated one ...

solved 6

SQL 55 years 62 Answers 2570 views Grand Master

Question 2

SQL interview question | Write the query

Question

We have two columns(Revenue and Cost Price) in a table like below, get me the Profit column Revenue Cost Price Profit 100 Null ...

solved 16

SQL 55 years 46 Answers 5425 views Grand Master

Question 3

Statistics Basics

Question

The mean of a distribution is 20 and the standard deviation is 5. What is the value of the coefficient of variation?

in progress 3

Statistics 55 years 43 Answers 4890 views Contributor

Question 4

What do you mean by mutable and immutable data type? Explain

Question

Why did you ask a definition here? Well, it's very important to understand the concept of mutable and immutable data types. Any good product based company will love to play with mutable and immutable indexed and unindexed ordered and unordered ...

solved 2

Python 55 years 37 Answers 2347 views Grand Master

Question 5

What is the use of OFFSET command?

Question

With coding example

solved 11

SQL 55 years 34 Answers 4945 views Grand Master

Question 6

SQL interview Question | Second Highest Salary – Method 1

Question

Write a SQL query to get second highest query using sub query

in progress 0

SQL 55 years 33 Answers 3865 views Grand Master

Question 7

Statistics Basics 3 | Interview Question

Question

According to the empirical rule, approximately what percent of the data should lie within μ±2σ?

in progress 0

Statistics 55 years 29 Answers 2719 views Contributor

Question 8

What is the order of execution of SQL commands?

Question

How does the SQL commands flow at the back end?

solved 6

SQL 55 years 27 Answers 6217 views Grand Master

Question 9

SQL interview Question | Second Highest Salary – Ranking

Question

Write a SQL query to get second highest query using Ranking

in progress 2

SQL 55 years 27 Answers 3076 views Grand Master

Question 10

Can you use HAVING command without any aggregate function in SQL?

Question

A bit tricky, do give a try

solved 3

SQL 55 years 27 Answers 6090 views Contributor

Question 11

Statistics Basics 2 | Interview Question

Question

Which of the following describe the middle part of a group of numbers? a. Measure of Variability b. Measure of Central Tendency c. Measure of Association d. Measure of Shape

in progress 0

Statistics 55 years 26 Answers 2378 views Contributor

Question 12

How much is the annual income of a beggar in Bangalore?

Question

Guesstimate

solved 6

Guesstimate 55 years 26 Answers 4307 views Grand Master

Question 13

Write a SQL query to find all the student names Nitin in a table

Question

Table is student column is name Make sure that you cover all the corner cases

solved 2

SQL 55 years 25 Answers 3214 views Contributor

Question 14

SQL Interview question

Question

Write a query to get all the student with name length 10, starting with K and ending with z

solved 3

SQL 55 years 25 Answers 3280 views Contributor

Question 15

How would you explain the concept of p-value to a layman ?

Question

In simple terms

solved 2

Statistics 55 years 24 Answers 2684 views Grand Master

Question 16

Demand and Supply increased by 10% but total booking was down by 10% for a particular week, Why?

Question

I work at Uber and found out that for a particular week, number of drivers who signed up for the service increased by 10% and so was the increase in the number of users using the app. But, the number ...

solved 3

Case Study 55 years 24 Answers 1630 views Grand Master

Question 17

What is the difference between xrange and range in Python?

Question

Explain with code please

in progress 0

Python 55 years 22 Answers 2047 views Contributor

Question 18

Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

Question

Write Query

in progress 1

SQL 55 years 22 Answers 18790 views Grand Master

Question 19

Suppose you have 10 samples, where 8 are positive and 2 are negative, how to calculate Entropy (important to know)

Question

A bit mathematical

in progress 1

Machine Learning 55 years 21 Answers 1939 views Grand Master

Question 20

What is the difference between forecasting and prediction?

Question

Both of these terms look similar

solved 1

Machine Learning 55 years 21 Answers 2586 views Grand Master

Question 21

Ranking in SQL

Question

We have the following values 10000 10000 20000 30000 30000 30000 What would be the result of row number, rank, and dense rank ?

solved 3

SQL 55 years 21 Answers 2602 views Contributor

Question 22

SQL Interview Questions | Alternate Rows

Question

You have data of people having applied for a lottery ticket. The data consists of their name and ticket number. You have to choose winners by selecting the people present in the alternate rows (first winner starting from row number ...

in progress 4

SQL 55 years 21 Answers 6211 views Great Grand Master

Question 23

SQL Interview Questions | Common Data

Question

Write a query for collecting the names of children who pursuing their graduation in their residential city. NAME AGE ADDRESS COLLEGE ……. …… ….. ….. (Hint- Look for the common city name in the columns of ADDRESS and COLLEGE) Example Nitin 26 Patna Patna Ankit 27 Bangalore Pune Result - Nitin

in progress 4

SQL 55 years 20 Answers 6202 views Great Grand Master

Question 24

Very briefly explain the assumptions of Linear Regression

Question

This might look like a standard subjective question but any interviewer will assume that you know at least Linear and Logistic Regression irrespective of whether it's mentioned on your resume. This is the first question you start with. Do not copy ...

solved 1

Machine Learning 55 years 20 Answers 1144 views Grand Master

Question 25

Help me create a table with all the employee Names and Manager Names. SQL OYO interview Questions

Question

Employee_Name Employee_Id Manager_Id A 1 2 B ...

in progress 4

SQL 55 years 18 Answers 2106 views Grand Master

Question 26

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 2502 views Grand Master

Question 27

Extract all the distinct email id domain from all the employee

Question

Suppose there are two columns in employee table i.e. emp id and email get all the unique domains like gmail.com, yahoo.com, outlook.com, etc.

solved 6

SQL 55 years 18 Answers 2913 views Grand Master

Question 28

Amazon Interview Question | What percentage of value lies between Mean and one Standard deviation(both positive and negative)

Question

.

solved 0

Statistics 55 years 18 Answers 3671 views Grand Master

Question 29

Difference in the formula of variance calculated for population and sample, Why?

Question

If you don't understand the question, then google it. Explore, what is variance, sample, population, etc.. Once you understand the concepts then come back to the question. The question checks your concept of degree of freedom and whether you have understood ...

solved 0

Statistics 55 years 18 Answers 2035 views Grand Master

Question 30

Calculate the cumulative multiplication

Question

Calculating sum is somewhat easy(though we will surely this in another question). We have 4 rows in a table T with column x 2 3 5 10 Output 2 6 30 300

solved 3

SQL 55 years 18 Answers 1694 views Grand Master

Question 31

Is set an indexed and ordered data type? If not then how do you actually access data from a set?

Question

I have a set with 4 values i.e. A,B,C, and D If I print the set again after assigning the values, will it show the values in the same order? If the values are not indexed then how to access these values?

solved 0

Python 55 years 18 Answers 1109 views Grand Master

Question 32

Can you join two table without any common column?

Question

Join interview question

in progress 3

SQL 55 years 17 Answers 3177 views Grand Master

Question 33

Lowe’s Interview Questions | Query I

Question

Name Designation Joining_Date Salary Ashutosh Singla HR 2019-12-15 80,000 Chandan Garg Admin 2019-10-09 60,000 Himanshi Kaur HR 2019-03-13 75,000 Mohit Dharm HR 2019-05-27 85,000 Meena Batra Accountant 2019-07-11 50,000 Omkar Singh Accountant 2019-01-05 45,000 Pratham Garg Admin 2019-05-27 65,000 Rakesh Sharma HR 2018-06-30 75,000 Sharadha Gupta Accountant 2019-09-18 50,000 Demonstrate how to write a query to show details of an HR whose name starts with M.

in progress 1

SQL 55 years 17 Answers 2898 views Great Grand Master

Question 34

Explain Missing Value Treatment by mean,mode, median, and KNN Imputation

Question

What is missing value treatment

solved 1

Machine Learning 55 years 16 Answers 7633 views Grand Master

Question 35

Flipkart Case Study | Restaurant optimization

Question

Punjabi By Nature is going through a rough phase and is wasting 30-40 Kgs of biryani on some days of the week. Management is thinking to find a method to sell the left over biryani or reduce the amount of biryani ...

solved 2

Case Study 55 years 16 Answers 16373 views Contributor

Question 36

Define Confidence interval in a very layman manner with example

Question

Confidence interval is something for which you can get N number of definitions, but what really matters is whether you understand the concept or not. Try to take any simple real life example and explain the concept. These are the basic questions ...

solved 0

Statistics 55 years 16 Answers 1014 views Grand Master

Question 37

You want to buy a restaurant in Gurgaon, you have the sales data of last 6 months but you do not have any survey. How would you come up with a price for this restaurant

Question

You plan to buy a restaurant at a price of 80 lac in Cyber City. You have to sales data of the last 6 months. You can assume any valid sales data along with that you also have employees data.

solved 0

Case Study 55 years 15 Answers 1157 views Grand Master

Question 38

SQL Query Output | EXL interview question

Question

select case when null=null then ‘Amit’ else ‘Rahul’ end from dual

in progress 2

SQL 55 years 14 Answers 2334 views Grand Master

Question 39

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

Question

Explain with any example code

solved 1

SQL 55 years 14 Answers 2306 views Grand Master

Question 40

Explain type 1 error in simplest terms

Question

confusion matrix

solved 0

Statistics 55 years 14 Answers 1963 views Grand Master

Question 41

Write a Python program to take a number and check if it’s a palindrome or not

Question

Now the trend has changed a bit, interviewer do not shy away from asking basic python programs. 12321 12345 Palindrome Non-Palindrome

solved 0

Python 55 years 14 Answers 1233 views Grand Master

Question 42

What do you mean when I say “The model has high accuracy in Training dataset but low in testing dataset

Question

Can you give an example?

solved 0

Machine Learning 55 years 13 Answers 1762 views Grand Master

Question 43

Explain type 2 error in simple terms

Question

Confusion matrix

in progress 0

Statistics 55 years 13 Answers 1732 views Grand Master

Question 44

Q1 | Guess the question

Question

All you have to do is to go through the code and comment the question for which the following is an answer of SELECT matchid, player FROM goal WHERE teamid = 'GER'

in progress 2

SQL 55 years 13 Answers 1886 views Grand Master

Question 45

What is indexing in SQL? Meredith India interview question

Question

Explain with proper example

in progress 2

SQL 55 years 12 Answers 2778 views Grand Master

Question 46

Define Loss function in the simplest way possible

Question

Where is it used ?

in progress 0

Statistics 55 years 12 Answers 1848 views Grand Master

Question 47

Define R squared error in simple terms

Question

Try not to use a lot of mathematics

in progress 0

Statistics 55 years 12 Answers 2115 views Grand Master

Question 48

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 4603 views Grand Master

Question 49

How do you measure distribution?

Question

Explain or give name of the methods used to measure distribution

in progress 0

Statistics 55 years 11 Answers 1724 views Grand Master

Question 50

What is the need to remove multicolinearity ?

Question

What would happen if we don’t remove it?

solved 0

Statistics 55 years 11 Answers 2093 views Grand Master

Register Now

Login

Lost Password

Welcome to The Data Monk