MullenLowe Lintas Group Interview Questions and Answers

Reasoning and logic base qus

Q1. About metrics like Cpc, cvr
Add your answer

Q1. Discuss about previous work
Add your answer

45 min very easy MCQ test on hacker rank covering aptitude , MySQL and MS Excel topics.

Q1. SQL queries,Python,Pandas,Numy,MS Excel
Add your answer

Q1. Behavioural questions
Add your answer

Q1. Prepare SQL and Pyspark well
Add your answer
Q2. Prepare well on SQL Joins
Add your answer

Q1. Read about Programmatic advertising
Add your answer

It was a virtual coding round with coding questions on Java fundamentals, Array, LinkedList

Questions on java fundamentals, some code snippets, Array

Q1. Behavioral round with discussion on previous experience and values
Add your answer

Questions on SQL excel and BI tools

Technical skills deep understanding

Q1. Execution of SQL
Ans. 
Execution of SQL involves writing and running queries to retrieve, manipulate, and manage data in a database.
• Write SQL queries to retrieve specific data from database tables

• Use SQL functions and operators to manipulate data

• Execute SQL statements to update or delete records in database

• Manage database schema by creating, altering, or dropping tables

• Optimize SQL queries for better performance
Answered by AI
Add your answer

Q1. Fitment round and cultural
Add your answer

Two Medium DSA questions, then questions about react and springboot

Q1. One map related question regarding sorting string according to number of occurance of characters in it.
Add your answer
Q2. Right view of tree (recursive and using level order)
Ans. 
Printing the right view of a tree using recursion and level order traversal.
• Recursively traverse the right subtree first and then the left subtree.

• For level order traversal, use a queue to store nodes at each level.

• Print the rightmost node at each level.

• Example: For tree 1-2-3-4-5, the right view is 1-2-4-5.
Answered by AI
Add your answer
Q3. Some dbms, os, system design related terminologies like (foreign key, primary key, difference between them, scaling and types of it, few question on os)
Add your answer

Q1. Basic oops concepts. with examples
Add your answer
Q2. Java specific question and to write abstract class, interface and state difference between them.
Add your answer
Q3. Solid design pattern question to implement it with given example.
Add your answer
Q4. Sql query, os related question (deadlocks, and it s resolution)
Add your answer

Q1. It was managerial round based solely on resume. asked about my internship work, how I perform in team, work which I have done in previous organisation.
Add your answer
Q2. Few fun topics and discussions
Add your answer

Calender, time, relationship

Q1. Interduction itself
Add your answer
Q2. Technical questions
Add your answer
Q3. Data structure and algorithms
Add your answer