Dunnhumby Senior Software Engineer Interview Questions and Answers

Q1. What is difference between function and stored procedure
Ans. 
Functions return a single value, while stored procedures can perform multiple operations and return multiple values.
• Functions return a single value, while stored procedures can return multiple values.

• Functions are called in SQL statements, while stored procedures are called using EXECUTE statement.

• Functions cannot have output parameters, while stored procedures can have output parameters.

• Functions cannot modify server ...read more
Answered by AI
Add your answer
Q2. How to implement custom exception in MVC
Ans. 
Custom exceptions can be implemented in MVC by creating a new class that inherits from Exception class.
• Create a new class that inherits from Exception class

• Override the constructor to pass a custom message to the base Exception class

• Throw the custom exception in the MVC controller or service layer
Answered by AI
Add your answer

Q1. OOps, C#, MVC, WEBAPI, Azure
Add your answer
Q2. Multiple inheritance concept in OOPs?
Ans. 
Multiple inheritance allows a class to inherit attributes and methods from more than one parent class.
• In multiple inheritance, a class can inherit from two or more parent classes.

• It can lead to the Diamond Problem where a class inherits from two classes that have a common ancestor.

• Languages like C++ support multiple inheritance.

• Example: class ChildClass : public ParentClass1, public ParentClass2 {}
Answered by AI
Add your answer
Q3. What is interface?
Ans. 
An interface in software development defines a contract for classes to implement, specifying methods and properties that must be included.
• Interfaces in programming languages like Java, C#, and TypeScript allow for multiple inheritance by defining a set of methods that a class must implement.

• Interfaces are used to enforce a common structure across different classes, promoting code reusability and maintainability.

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

Create Crud operation using angular with API.

Q1. Mostly on your experience. Azure, .net core, microservices.
Add your answer
Q2. Coding round with basic programming questions. Easy level.
Add your answer

Q1. Js questions and 2 coding questions
Add your answer
Q2. Questions on angular, html and css
Add your answer

Round 1 - Learn the Important concepts of Aptitude like Time and work, Speed, Age related, English vocabulary etc.

Round 2 - GD
which is based on individual like how to interact and showing them your communication skills in a better way can get you to next and last round.

Q1. Round 3 - Interview 1. Asked on my personal life 2. About my project 3. Future plans.
Add your answer
Q2. Tell me about yourself?
Add your answer
Q3. Explain me about your project?
Add your answer
Q4. What are your future plans?
Add your answer

Q1. Coding test on sql and logical programming
Add your answer

Q1. Coding on sql and tsql
Add your answer

Q1. Manager round, general discussion
Add your answer

Q1. Company benefits and Salary discussion
Add your answer