SOTI Associate Software Developer Interview Questions and Answers

Q1. DSA Array, String and Hashmap questions
Add your answer
Q2. Functional programming java questions
Add your answer

Q1. Spring and spring boot related
Add your answer
Q2. HLD scenario level questions
Add your answer
Q3. SQL queries nested and joins
Add your answer
Q4. DB related questions and experience level questions and previous project situations related questions
Add your answer
Q5. Security level questions like XSS vulnerability and SQL injection
Add your answer

Q1. What is the inheritance?
Ans. 
Inheritance is a mechanism in object-oriented programming where a class inherits properties and behaviors from another class.
• Allows a class to inherit attributes and methods from another class

• Promotes code reusability and reduces redundancy

• Creates a parent-child relationship between classes

• Derived class can override or extend the functionality of the base class
Answered by AI
Add your answer
Q2. What are the types of joins in mysql
Ans. 
Types of joins in MySQL include inner join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full join: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer

Q1. How to handle multiple api's
Ans. 
Use a centralized API gateway to manage and route requests to multiple APIs efficiently.
• Implement a centralized API gateway to handle incoming requests and route them to the appropriate API based on the endpoint.

• Utilize API management tools like Apigee, Kong, or AWS API Gateway to manage and monitor multiple APIs.

• Consider implementing a caching layer to improve performance and reduce the number of requests to external
Answered by AI
Add your answer
Q2. What does strstr function do?
Ans. 
strstr function searches for a substring within a string and returns a pointer to the first occurrence of the substring.
• Used in C programming language

• Syntax: char *strstr(const char *haystack, const char *needle)

• Example: char *str = strstr("hello world", "world")
Answered by AI
Add your answer

Java internals, coding questions 2sum

Q1. Hld of your previous project
Ans. 
Developed a web-based project management tool for tracking tasks and deadlines.
• Used React.js for front-end development

• Implemented RESTful APIs for backend using Node.js and Express

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q2. Question related to self build projects
Add your answer

Q1. Salary negotiation
Add your answer
Q2. Location constrain if any
Ans. 
Open to relocation for the right opportunity
• Willing to relocate for the right job opportunity

• Flexible with location for the right role

• Open to considering different locations for the right position
Answered by AI
Add your answer

Q1. Explain the technology stack you have been working on.
Ans. 
I have been working on a technology stack that includes Java, Spring Boot, Angular, and MySQL.
• Java programming language for backend development

• Spring Boot framework for building and deploying Java applications

• Angular framework for frontend development

• MySQL database for data storage and retrieval
Answered by AI
Add your answer
Q2. Deep dive into the .Net framework and its use in developing microservices using Web APIs
Ans. 
The .Net framework is a powerful tool for developing microservices using Web APIs.
• The .Net framework provides a set of libraries and tools for building scalable and reliable microservices.

• Web APIs in .Net allow for easy communication between different services and clients.

• Features like dependency injection and middleware in .Net make it easier to develop and maintain microservices.

• Examples of popular frameworks for bui...read more
Answered by AI
Add your answer

Q1. Explain how you would troubleshoot a network bottleneck in your web API application hosted in a public cloud like Azure or AWS.
Ans. 
To troubleshoot a network bottleneck in a web API application hosted in a public cloud like Azure or AWS, one can analyze network traffic, monitor server performance, and optimize resource allocation.
• Use network monitoring tools to analyze traffic patterns and identify potential bottlenecks.

• Monitor server performance metrics such as CPU usage, memory usage, and disk I/O to pinpoint any resource constraints.

• Optimize res...read more
Answered by AI
Add your answer
Q2. Explain the usage of Azure service fabric clusters
Ans. 
Azure Service Fabric clusters are used to deploy and manage microservices-based applications on Microsoft Azure.
• Azure Service Fabric clusters provide a platform for deploying and managing scalable and reliable microservices.

• They offer automatic scaling, rolling upgrades, and health monitoring for microservices.

• Service Fabric clusters can be used to deploy stateless or stateful microservices.

• They support multiple progra...read more
Answered by AI
Add your answer

Q1. Java,oop, microservice, JPA
Add your answer
Q2. Spring boot , MySQL
Add your answer

Q1. Java, spring boot
Add your answer
Q2. Microservice, rest api
Add your answer

Q1. Tell me about your self
Ans. 
I am a passionate software developer with 5 years of experience in building web applications using various technologies.
• 5 years of experience in software development

• Proficient in building web applications

• Skilled in using various technologies
Answered by AI
Add your answer
Q2. Resume discussion
Add your answer

It was a 90minutes coding test where there was 2 coding question and 10 mcq each coding question carried 33% marks and even the 10mcq was 33% marks

Q1. Like it was full based on resume like on my resume i had put two web projects so most of the question was from web development and the aws cloud it took a lot of time and at last they asked the coding ques...read more
Add your answer

Q1. Hr was easy just asked to introduce about myself and tell any one preffered project
Add your answer

Q1. Threading: Write and use a mutex?
Ans. 
A mutex is a synchronization primitive that ensures only one thread can access a resource at a time.
• Create a mutex object using the appropriate library or language-specific function.

• Lock the mutex before accessing the shared resource to prevent other threads from accessing it.

• Unlock the mutex after finishing the operation on the shared resource to allow other threads to access it.

• Example: pthread_mutex_t mutex; pthread...read more
Answered by AI
Add your answer
Q2. Find the memory leak in a given set of code.
Ans. 
Identify memory leak in code
• Check for any dynamically allocated memory that is not being freed

• Look for any infinite loops or recursive functions that consume memory

• Use memory profiling tools like Valgrind to detect leaks

• Check for any global variables that are not properly managed
Answered by AI
Add your answer