Landmark Group Interview Questions, Process, and Tips for Freshers

Q1. Tell me About yourself
Add your answer
Q2. Explain your current role
Add your answer
Q3. A few scenarios were given and question were asked around that . (RCA, Prioritization, Metrics)
Add your answer

Product Case study . Question was there has been significant increase in the returns at your ecommerce platform . Find out Why and then solve this problem

Q1. Prepare All theoretical questions related to SQL and excel. Learn everything about your resume so that you will be able to explain each and everything about the resume.
Add your answer
Q2. Difference between Vlookup and Xlookup ?
Ans. 
Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.
• Vlookup searches vertically in a table and returns a value from a specified column.

• Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.

• Vlookup requ...read more
Answered by AI
Add your answer
Q3. Difference between Subquery and CTE. Which is better?
Ans. 
Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.
• Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

• CTE is defined using the WITH keyword and can be referenced multiple times in a query.

• CTEs are more readable and easier to maintain compared to subqueries.

• Subqueries are useful when t...read more
Answered by AI
Add your answer
Q4. No of records returned after applying left and inner join on 2 tables.
Add your answer
Q5. Pivot the table in SQL using case when statements.
Ans. 
Pivoting a table in SQL using case when statements
• Use the CASE WHEN statement to create new columns based on specific conditions

• Use the SUM or COUNT function to aggregate data in the pivoted table

• Group by the remaining columns to ensure correct aggregation

• Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;
Answered by AI
Add your answer

Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data

Q1. Tell me about yourself in detail and also about your relevant experiences.
Ans. 
I am a motivated product management intern with a strong background in marketing and project management.
• Completed a marketing internship at XYZ Company

• Led a cross-functional team to launch a new product

• Proficient in market research and analysis

• Strong communication and problem-solving skills
Answered by AI
Add your answer
Q2. How do you think you can solve poverty in India.
Ans. 
Poverty in India can be addressed through a combination of economic policies, social programs, and education initiatives.
• Implementing targeted poverty alleviation programs to provide financial assistance to those in need

• Promoting job creation and economic growth through investment in infrastructure and industries

• Improving access to education and vocational training to enhance skills and employability

• Addressing social i...read more
Answered by AI
Add your answer

Q1. Retail Background
Add your answer
Q2. Details of Garments Apparel
Add your answer