Aster Dm Healthcare Senior Sdet Software Engineer Interview Questions and Answers

In 1 hr required to do 30 mcq and 1 coding question

Q1. Find 2nd max by sql, do Fibonacci series
Ans. 
SQL query to find 2nd max and Fibonacci series implementation
• For finding 2nd max, use ORDER BY and LIMIT in SQL query

• For Fibonacci series, use a loop or recursive function

• Fibonacci series starts with 0, 1 and each subsequent number is the sum of the previous two

• Example SQL query: SELECT MAX(column_name) FROM table_name WHERE column_name < (SELECT MAX(column_name) FROM table_name)

• Example Fibonacci series: 0, 1, 1, 2, 3,
Answered by AI
Add your answer

Q1. Question related to project and discussion related to technology in resume in somewhat deep
Add your answer