Omnicom Group Interview Questions and Answers

40/50marks

They ask fibanocci series , basic c programs

Discuss about general topic

Write a essay on your own life

Q1. Css HTML tags,sql,angul
Add your answer
Q2. Angular js dot net developer
Add your answer
Q3. Web configuration , CTS
Add your answer

Q1. Salery discussion and expecting ctc
Add your answer
Q2. Will you think are you okay
Add your answer

Q1. They are asking technical questions what is their in the resume
Add your answer

Q1. They will technical questions as per your resume what you mentioned
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

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. Work experience related
Add your answer

Q1. C# oops polymorphism extension methods
Ans. 
Polymorphism is a key feature of OOP in C#. Extension methods allow adding new functionality to existing types.
• Polymorphism allows objects of different classes to be treated as if they are of the same type.

• Extension methods are static methods that can be called as if they were instance methods of the extended type.

• Polymorphism and extension methods can be used together to add new behavior to existing types without modi
Answered by AI
Add your answer
Q2. Angular javascript vs typescript services components
Ans. 
Angular is a framework for building web applications using TypeScript, which is a superset of JavaScript.
• Angular provides a structure for building web applications using components, services, and modules.

• TypeScript is a statically typed language that provides better tooling and error checking than JavaScript.

• Services in Angular are used for sharing data and functionality across components.

• Components in Angular are the ...read more
Answered by AI
Add your answer

General grammar questions for checking the english proficiency of the candidates

Q1. You'll have a direct one on one with the elad and they will enquire about yourself and your skills, especially they will check your communication skills
Add your answer
Q2. What is Adobe and Office 365
Ans. 
Adobe and Office 365 are software suites commonly used for various business purposes.
• Adobe is a software suite used for graphic design, video editing, and web development.

• Office 365 is a cloud-based suite of productivity applications including Word, Excel, PowerPoint, and Outlook.

• Both Adobe and Office 365 are widely used in businesses for creating, editing, and sharing documents and multimedia content.
Answered by AI
Add your answer
Q3. Communication skills test
Add your answer

It consited of apti as well as coding questions

Q1. Basic questions of coding were asked like arrays,strings
Add your answer