Mordor Intelligence Senior Software Engineer Interview Questions and Answers

They will ask some simple algorithmic questions.

Q1. Very friendly face to face interview simple questions will be asked base on your level of expertise
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

Q1. Questions were mainly based on work experience and resume
Add your answer
Q2. AWS Question regarding S3, saprk memory
Add your answer

Mix of coding, aptitude, java, javascript

Q1. Resume based questions on project
Add your answer
Q2. Basic SQL, Java streams questions
Add your answer

Q1. Project related questions
Add your answer
Q2. Internal working of hashmap
Ans. 
HashMap is a data structure that stores key-value pairs and uses hashing to quickly retrieve values based on keys.
• HashMap internally uses an array of linked lists to store key-value pairs.

• When a key-value pair is added, the key is hashed to determine the index in the array where the pair will be stored.

• If multiple keys hash to the same index, a collision occurs and the pairs are stored in a linked list at that index.

• To...read more
Answered by AI
Add your answer
Q3. Design patterns I've used
Ans. 
I have used design patterns such as Singleton, Factory, and Observer in my projects.
• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• Factory pattern creates objects without specifying the exact class of object that will be created.

• Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and
Answered by AI
Add your answer
Q4. Print whole Fibonacci series using recursion.
Ans. 
Print Fibonacci series using recursion
• Define a recursive function to calculate Fibonacci numbers

• Base case: return 0 if n is 0, return 1 if n is 1

• Recursive case: return sum of previous two Fibonacci numbers

• Print each Fibonacci number in the series
Answered by AI
Add your answer
Q5. Show my Github projects, and the interviewer didn't even properly looked into the code.
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. Third party took the interview. Basics of programming and database were asked.
Add your answer

Q1. Asked to build a small game. LLD round.
Add your answer

3 simple coding questions

Q1. Merge sort with list
Ans. 
Merge sort is a divide and conquer algorithm that recursively divides the input array into smaller subarrays, sorts them, and then merges them back together.
• Divide the input list into two halves

• Recursively apply merge sort to each half

• Merge the sorted halves back together
Answered by AI
Add your answer
Q2. Similar to coin exchange DP
Add your answer
Q3. SQL query medium level
Add your answer