Grey Orange Senior Design Engineer Interview Questions and Answers

Q1. Write an SQL query to fetch duplicates.
Ans. 
SQL query to fetch duplicates
• Use GROUP BY and HAVING clause to identify duplicates

• Select columns to be checked for duplicates

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q2. Write SQL query to fetch nth highest Salary.
Ans. 
SQL query to fetch nth highest Salary
• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary

• Consider handling cases where there might be ties for the nth highest salary
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

Hacker rank coding tesr

Q1. Relational database queries
Add your answer
Q2. Coding Question on JavaScript
Add your answer

Q1. Advantage and disadvantage of framework.
Ans. 
Frameworks provide structure and pre-built components for software development, but can also limit flexibility and require learning curve.
• Advantage: Provides structure and pre-built components for faster development

• Advantage: Can improve code quality and maintainability

• Disadvantage: Can limit flexibility and customization

• Disadvantage: Requires learning curve and potential dependency issues

• Example: ReactJS provides a fr...read more
Answered by AI
Add your answer

Q1. What is Oops? Advantage and disadvantage
Ans. 
Oops stands for Object-Oriented Programming. It is a programming paradigm that uses objects to represent real-world entities.
• Advantages: code reusability, modularity, encapsulation, inheritance, polymorphism

• Disadvantages: complexity, steep learning curve, performance overhead

• Example: creating a class 'Car' with properties like 'make', 'model', and 'year', and methods like 'start_engine' and 'stop_engine'
Answered by AI
Add your answer

Q1. Backend Questions regarding
Add your answer
Q2. UI Questions regarding Angular
Add your answer

Q1. Core and Advance concepts of Java
Add your answer

Q1. Mainly on mutltithrerading concepts and previous experience on projects.
Add your answer

Q1. About projects and scenarios based questions.
Add your answer

Q1. About Salary negotiation and final round
Add your answer