Scribe EMR Senior 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. 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

First round was on Hacker Earth

Q1. Technical round was on Spring Data Jpa, Pagination, SOLID principles
Add your answer

Q1. Core java concepts,Sql queries,2 coding question based on arrays and string
Add your answer
Q2. Reverse the string
Ans. 
Reverse a given string
• Use a loop to iterate through the characters of the string

• Swap the characters from start to end to reverse the string

• Return the reversed string
Answered by AI
Add your answer
Q3. Find third highest salary from a employee table
Add your answer

Q1. Advance java and project related
Add your answer
Q2. Springboot and spring diff
Add your answer
Q3. Springboot annotations used in your project
Ans. 
Some common Springboot annotations used in projects are @RestController, @Autowired, @RequestMapping, @Service, @Component, @Repository.
• @RestController - Used to define RESTful web services.

• @Autowired - Used for automatic dependency injection.

• @RequestMapping - Used to map web requests to specific handler methods.

• @Service - Used to indicate that a class is a service.

• @Component - Used to indicate that a class is a Spring...read more
Answered by AI
Add your answer
Q4. Springboot dependencies
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

There are 30 basic aptitude question in 30 minutes

3 coding question 2 were easy and 1 was of medium level

In Mu Sigma APT round is divided into 3 sections Quant, Logical and verbal