Myntra Senior Officer Interview Questions and Answers

Q1. Sql of no of rows
Ans. 
To find the number of rows in a SQL table, use the COUNT() function.
• Use the COUNT() function in SQL to count the number of rows in a table.

• Example: SELECT COUNT(*) FROM table_name;

• Make sure to replace 'table_name' with the actual name of the table you want to count rows for.
Answered by AI
Add your answer

Q1. Guesstimate question
Add your answer
Q2. Sql join, group by
Add your answer

Q1. Relivent experience
Add your answer

Q1. Previous experience asked
Add your answer

Q1. Standard SQL Questions
Add your answer

Preparing media plan for app campaign at a certain budget and expected installs first orders etc

Q1. Guessestimate and general mathematical aptitude
Add your answer
Q2. No of petrol pumps in city
Ans. 
The number of petrol pumps in the city is not available.
• I do not have access to the data on the number of petrol pumps in the city.

• It would be best to consult the city's government or relevant authorities for this information.

• Alternatively, one could conduct a survey or research to estimate the number of petrol pumps in the city.
Answered by AI
Add your answer
Q3. How would you optimize the campaigns in terms of bids budgets
Ans. 
Optimizing bids and budgets involves analyzing data, setting goals, and adjusting strategies accordingly.
• Analyze campaign data to identify top-performing keywords and adjust bids accordingly

• Set clear goals for each campaign and allocate budgets accordingly

• Regularly monitor and adjust bids and budgets based on performance data

• Consider using automated bidding strategies to save time and improve efficiency

• Use A/B testing ...read more
Answered by AI
Add your answer

Q1. Why do you want to join meesho
Add your answer
Q2. Basics of Digital marketing CPM CTR CPC difference
Add your answer

Case study on how to improve the app traffic

Q1. SQL, Advanced Excel,x
Add your answer
Q2. Business I ntelligence tools
Add your answer

Q1. Guesstimators,puzzle
Add your answer
Q2. Puzzle.guesstimators
Add your answer

Q1. SQL hakcerank test, 10 questions 1 hour
Add your answer
Q2. On sql mainly, with some python and Excel.
Add your answer