Saras Analytics Software Engineer Intern Interview Questions and Answers

Basic aptitude concepts

2 Questions on sorting and profit related question

Q1. Technical questions like oops,sql queries. And previous round coding question different approaches.
Add your answer
Q2. Sorting question
Add your answer
Q3. Sql query on 2nd highest salary
Ans. 
Use SQL query with ORDER BY and LIMIT to find the 2nd highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 1,1 to skip the first highest salary and get the second highest salary
Answered by AI
Add your answer
Q4. Difference between tuple and delete command
Ans. 
Tuple is a data structure that stores a fixed number of elements, while delete command is used to remove data from a database table.
• Tuple is used to store multiple values in a single variable, while delete command is used to remove specific rows from a database table.

• Tuples are immutable, meaning their values cannot be changed once they are set, while delete command permanently removes data from a table.

• Example: Tuple ...read more
Answered by AI
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