Love In Store Marketing Executive Interview Questions and Answers

There were 10 questions and we were given 30 mins to solve them , questions were medium to hard level mcq

Question based on Probability , Logic (Puzzles) , Statistics

Q1. Question based on Logic(Puzzles) , mostly Statistics
Add your answer
Q2. Explain Anova Test with real time example
Ans. 
Anova Test is used to compare means of three or more groups.
• Anova stands for Analysis of Variance

• It is used to determine if there is a significant difference between the means of three or more groups

• It compares the variance within groups to the variance between groups

• Real-time example: An Anova test can be used to compare the average salaries of employees in different departments of a company
Answered by AI
View 1 more answer

Q1. Asked different variety of puzzles
Add your answer

Two coding questions and 15 mcq

Q1. Questions on priority queue
Add your answer
Q2. Question on dp , stack were askef
Add your answer

Q1. Graph related questions
Add your answer
Q2. Database related questions
Add your answer

Q1. If you are fine with flexible timings
Ans. 
Yes, I am fine with flexible timings as it allows me to manage my work-life balance effectively.
• I am comfortable with flexible timings as it helps me accommodate personal commitments.

• I believe in focusing on productivity rather than strict working hours.

• I am adaptable and can work efficiently regardless of the time of day.

• I can provide examples of times when flexible timings have benefited my work performance.
Answered by AI
Add your answer
Q2. Discussed about projects
Add your answer

We have given 12 puzzles on hackerearth based on probability and statistics and have to solve in 45 minutes

Q1. There is a biased dice with the probability of 1 and 2 is 25% each. Find the probability of even number.
Ans. 
The probability of rolling an even number on a biased dice with 25% chance for 1 and 2 is 50%.
• The biased dice has a 25% chance for rolling a 1 and a 25% chance for rolling a 2, totaling 50% for odd numbers.

• Since there are only two odd numbers on a dice (1 and 2), the probability of rolling an even number is 50%.

• The probability of rolling an even number on a standard dice is 50% as well, since there are 3 even numbers o
Answered by AI
Add your answer
Q2. What is the pdf and pmf?
Ans. 
PDF stands for Probability Density Function and PMF stands for Probability Mass Function.
• PDF is used for continuous random variables while PMF is used for discrete random variables.

• PDF represents the probability distribution of a continuous random variable.

• PMF represents the probability distribution of a discrete random variable.

• Example: PDF can be used to calculate the probability of a random variable falling within a...read more
Answered by AI
Add your answer

Few questions that would involve problem solving. Basic 10th std math would suffice

Had few DSA questions.

Q1. Technical interview
Add your answer

Q1. About job, expection etc
Add your answer

Q1. Basic 10-15btheorotical question
Add your answer
Q2. Join + window funct question
Add your answer

Q1. Difference Between Union and Union All
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Answered by AI
Add your answer
Q2. SQL Execution order
Add your answer
Q3. Coalesce function in SQL
Ans. 
Coalesce function in SQL is used to return the first non-null value in a list of expressions.
• Coalesce function takes multiple parameters and returns the first non-null value.

• It is commonly used to handle null values in SQL queries.

• Example: SELECT COALESCE(column_name, 'N/A') FROM table_name;
Answered by AI
Add your answer