GE Aviation OJT Interview Questions and Answers

Q1. Previous experience
Add your answer
Q2. About projects and subjects
Add your answer

Q1. Find the second highest salary in sql
Ans. 
Use SQL query with ORDER BY and LIMIT to find the second highest salary.
• Use SELECT statement to retrieve salary column from the table.

• Use ORDER BY clause to sort the salaries in descending order.

• Use LIMIT 1,1 to get the second highest salary.
Answered by AI
Add your answer
Q2. Check duplicate rows using sql, group by, window function.
Ans. 
Use SQL query with GROUP BY and window function to check for duplicate rows.
• Use GROUP BY to group rows with same values together

• Use COUNT() function to count the number of occurrences of each group

• Use window function like ROW_NUMBER() to assign a unique number to each row within a group
Answered by AI
Add your answer

Q1. Tell me about your self
Ans. 
I am a motivated and detail-oriented individual with a passion for learning and problem-solving.
• I have a strong work ethic and enjoy taking on new challenges.

• I have experience in [relevant field or industry].

• I am proficient in [specific skills or software].

• I am a team player and enjoy collaborating with others.

• I am eager to continue growing and developing both personally and professionally.
Answered by AI
Add your answer

Q1. Tell me about your self
Ans. 
I am a motivated and detail-oriented individual with a passion for learning and problem-solving.
• I have a strong work ethic and am always eager to take on new challenges.

• I have experience in various internships where I have honed my skills in research, analysis, and communication.

• I am a quick learner and adapt well to new environments and tasks.

• I am currently pursuing a degree in [Your Field of Study] at [Your Universit
Answered by AI
Add your answer
Q2. What do you know about surface treatment
Ans. 
Surface treatment is a process used to modify the surface of a material to improve its properties or appearance.
• Surface treatment can involve cleaning, etching, coating, or plating the surface of a material.

• Common methods of surface treatment include anodizing, electroplating, and powder coating.

• Surface treatment can improve properties such as corrosion resistance, wear resistance, and adhesion.

• Examples of surface trea...read more
Answered by AI
Add your answer

Q1. Node js working in detail
Ans. 
Node.js is a runtime environment that allows you to run JavaScript on the server side.
• Node.js is built on Chrome's V8 JavaScript engine.

• It uses an event-driven, non-blocking I/O model that makes it lightweight and efficient.

• Node.js is commonly used for building server-side applications, APIs, and real-time applications.

• It has a large ecosystem of libraries and frameworks, such as Express.js and Socket.io.
Answered by AI
Add your answer
Q2. Timer working in node
Ans. 
In Node.js, timers can be implemented using functions like setTimeout() and setInterval().
• Use setTimeout() to execute a function once after a specified delay

• Use setInterval() to execute a function repeatedly at a specified interval

• Clear a timer using clearTimeout() or clearInterval()

• Example: setTimeout(() => { console.log('Timer executed!'); }, 2000);
Answered by AI
Add your answer

Q1. HLD questions on db and backend
Add your answer
Q2. Relational non relational db
Add your answer

Q1. JS basic questions
Add your answer

Verbal, reasoning,etc.

2 question were3 asked

A topic was given on techinal fields.