Leo Burnett Interview Questions and Answers

Q1. Explain oops concepts, difference b/w abstraction and interface,MVC architecture,stored procedure,joins
Ans. 
OOPs concepts, abstraction vs interface, MVC architecture, stored procedures, joins
• OOPs concepts include inheritance, polymorphism, encapsulation, and abstraction

• Abstraction is hiding the implementation details while interface is a contract that defines the methods that a class must implement

• MVC architecture separates the application into Model, View, and Controller components for better organization and maintenance

• Sto...read more
Answered by AI
Add your answer

SQL queries, ddl,dml TCL commands, primary key and foreign key differences,what is composite key,hash table in c#,generics in c#.

Q1. Salary discussion,
Add your answer

Q1. Pivot columns in sql
Ans. 
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
• Use the PIVOT keyword in SQL to pivot columns

• Specify the columns to pivot on and the values to display in the new columns

• Aggregate functions like SUM, AVG, COUNT can be used with PIVOT

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
Answered by AI
Add your answer
Q2. Slow changing dimensions
Add your answer
Q3. Dynamic rankx top 3
Add your answer
Q4. Field parameters
Add your answer
Q5. Stored procedures
Add your answer

Simple aptitude questions

One easy leetcode problem and few MCQ on SQL/SAS/R/Python

Q1. Interview on statistics, probability
Add your answer

Q1. Behavioural questions
Add your answer