Omnicom Media Group Senior Software Engineer Interview Questions and Answers

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

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. What is invoke controller?
Ans. 
Invoke controller is a component in a software application that manages the flow of requests and responses between the user interface and the backend services.
• Manages the communication between user interface and backend services

• Handles the routing of requests to appropriate functions or methods

• Coordinates the flow of data and actions within the application
Answered by AI
Add your answer
Q2. What is facade in laravel?
Ans. 
Facade in Laravel is a design pattern that provides a simple interface to a complex subsystem.
• Facade provides a static interface to classes that are available in the application's service container.

• It is used to simplify the usage of complex classes by providing a simpler interface.

• Facade allows you to access Laravel's features without needing to instantiate objects or use dependency injection.

• Example: The Auth facade ...read more
Answered by AI
Add your answer

HackerRank Test, basic questions related to the profile.

Q1. Coding Interview with the team manager
Add your answer

Q1. What are synthetic Events?
Ans. 
Synthetic Events are events that are created by the browser to mimic real user events.
• Synthetic Events are used in React to handle events in a consistent manner across different browsers.

• They are created by React to wrap native browser events and provide additional functionality.

• Examples include onClick, onChange, and onSubmit events in React.
Answered by AI
Add your answer
Q2. What is event bubbling?
Ans. 
Event bubbling is the process where an event triggered on a child element is propagated up through its parent elements.
• Event bubbling allows a single event handler to be attached to a parent element, which will be triggered for all its children.

• When an event occurs on a child element, it first runs the event handlers on the child, then on its parent, and so on up the DOM tree.

• Event bubbling can be stopped using event.s
Answered by AI
Add your answer

Easy leetcode data structure question

Q1. Write working code for calling a rest API, design rate limiter
Ans. 
Code for calling a REST API and designing a rate limiter
• Use a library like requests or axios to make the API call

• Implement a token bucket algorithm for rate limiting

• Set a maximum number of requests per second and queue excess requests

• Consider using a distributed rate limiter for scalability
Answered by AI
Add your answer

Q1. Design Database schema for instagram
Ans. 
Design a database schema for Instagram.
• Create tables for users, posts, comments, likes, and follows.

• Use primary and foreign keys to establish relationships between tables.

• Store user data such as username, email, and password securely.

• Include fields for post content, location, and timestamp.

• Track likes and comments on posts.

• Implement a notification system for follows and likes.

• Consider scalability and performance in the...read more
Answered by AI
Add your answer

Q1. Laravel framework question.
Add your answer

Q1. Laravel framework question
Add your answer