Groupm Media Media Planner Interview Questions and Answers

1hr exam which was very easy

Q1. Why should we hire you introduce yourself whats ur weakness why choose non it background
Add your answer

Q1. Why choose non it background?
Add your answer

Q1. Basic Accounting principles
Add your answer

Q1. IND AS 116, IND AS 115, IND AS 110 Financial Ratios, Profitability Ratios
Add your answer

Q1. Introduction, profile discussion, explanation of current job profile.
Add your answer

Q1. Previous Job discussions, Current Role discussions, most of the question will be based on previous work experience and situations.
Add your answer

Q1. Difference between union and union all in SQL?
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. How to show top 5 in pandas?
Ans. 
To show top 5 in pandas, use the nlargest() function.
• Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.

• For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.
Answered by AI
Add your answer

Q1. If we have 3 numerical columns, which chart is a better representation these column?
Ans. 
A scatter plot is a better representation for 3 numerical columns.
• Use a scatter plot to show the relationship between the numerical columns.

• Scatter plots are effective for visualizing correlations and patterns in data.

• Each point on the plot represents a data point with values from all 3 columns.
Answered by AI
Add your answer

Q1. Tell me about your projects
Add your answer
Q2. Tell me yourself
Add your answer

Q1. What are SQL Joins?
Ans. 
SQL Joins are used to combine rows from two or more tables based on a related column between them.
• SQL Joins are used to retrieve data from multiple tables based on a related column between them.

• Common types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer
Q2. Different functions in Python numpy
Ans. 
Python numpy provides various functions for numerical operations on arrays.
• numpy.sum() - calculates the sum of array elements

• numpy.mean() - calculates the mean of array elements

• numpy.max() - returns the maximum value in an array

• numpy.min() - returns the minimum value in an array

• numpy.std() - calculates the standard deviation of array elements
Answered by AI
Add your answer

Q1. Latest brand work. Hands on experience with day to day jobs
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Tell me about yourself.
Add your answer

Q1. About myself, Few technical questions, MDM process
Add your answer