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

Round one was an online coding test where there were 5 sections :

1 - dsa - medium

2 - Java - Easy

3 - OOP - Easy

4 - Git - Easy

Q1. 1 - where is bean annotation used in springboot ?... In class or method
Ans. 
Bean annotation is used in Spring Boot on class or method to indicate that a method produces a bean to be managed by the Spring container.
• Bean annotation is used on methods within a class to indicate that the method produces a bean to be managed by the Spring container.

• It can also be used at the class level to indicate that the class itself is a Spring bean.

• For example, @Bean annotation can be used on a method that cre...read more
Answered by AI
Add your answer
Q2. Which access modifier to restrict interface method access to only derived or implemented classes
Ans. 
Protected access modifier restricts interface method access to only derived or implemented classes.
• Use 'protected' access modifier to restrict access to only derived or implemented classes

• Protected members are accessible within the same package or by subclasses

• Example: 'protected void methodName() {}' in an interface
Answered by AI
Add your answer
Q3. How does one services interact with other in microservice
Ans. 
Microservices interact with each other through APIs, messaging, or events.
• Microservices communicate with each other through APIs, which can be synchronous or asynchronous.

• Messaging systems like RabbitMQ or Kafka can be used for communication between microservices.

• Events can be used for loosely coupled communication between microservices.

• Service discovery mechanisms like Eureka or Consul help microservices locate and co...read more
Answered by AI
Add your answer
Q4. In an integer array where element represent stock price and index represent days how to detect the best day to buy and best day to sell in O(N)
Ans. 
To detect the best day to buy and sell stock in an integer array representing stock prices and days in O(N).
• Iterate through the array and keep track of the minimum price seen so far.

• Calculate the profit by subtracting the current price from the minimum price.

• Update the maximum profit and best buy/sell days accordingly.

• Return the best buy and sell days to maximize profit.
Answered by AI
Add your answer
Q5. In an integer array find the next greatest number for all and display in O(N)
Ans. 
Find the next greatest number for each integer in an array in O(N) time complexity.
• Iterate through the array from right to left

• Use a stack to keep track of potential next greatest numbers

• Pop elements from the stack that are less than the current element and update their next greatest number to the current element

• Push the current element onto the stack

• Repeat until all elements have a next greatest number
Answered by AI
Add your answer

Q1. What fifo? diff btwn fifo and lifo
Ans. 
FIFO stands for First In, First Out. LIFO stands for Last In, First Out.
• FIFO is a method for organizing and manipulating a data buffer, where the first element added is the first to be removed.

• LIFO is a method where the last element added is the first to be removed.

• FIFO is like a queue, while LIFO is like a stack.

• Example: In a FIFO queue, if elements A, B, and C are added in that order, they will be removed in the same...read more
Answered by AI
Add your answer

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

Q1. Minimum in Rotated Sorted array
Ans. 
Find the minimum element in a rotated sorted array.
• Perform binary search to find the pivot point where the array is rotated.

• Compare the element at pivot point to the first element to determine which half to search for the minimum.

• Continue binary search in the appropriate half to find the minimum element.
Answered by AI
Add your answer
Q2. API and DB Schema for Instagram based application.
Ans. 
API for Instagram application to interact with user data and DB schema to store user information and posts.
• API endpoints for user authentication, posting photos, liking photos, following users, etc.

• DB schema with tables for users, posts, comments, likes, followers, etc.

• Example API endpoint: /users/{userId}/posts to retrieve all posts by a specific user.

• Example DB schema: Users table with columns for username, email, pr
Answered by AI
Add your answer

Q1. Resume introspection, AWS, K8s
Add your answer

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