EMERSON PROCESS MANAGEMENT Graduate Engineer Interview Questions and Answers

Q1. About Resume Projects
Add your answer
Q2. What are triggers in sql
Ans. 
Triggers in SQL are special stored procedures that are automatically executed when certain events occur in a database.
• Triggers can be used to enforce business rules, maintain referential integrity, and audit changes to data.

• Examples of triggers include BEFORE INSERT, AFTER UPDATE, and INSTEAD OF DELETE.

• Triggers can be defined at the table level and can be set to execute before or after an event.
Answered by AI
Add your answer

Q1. Preorder , post-order and in-order traversal of tree
Ans. 
Tree traversal methods in computer science
• In-order traversal: Left, Root, Right

• Pre-order traversal: Root, Left, Right

• Post-order traversal: Left, Right, Root

• Example: In-order traversal of tree with nodes 1, 2, 3 would be 1, 2, 3
Answered by AI
Add your answer
Q2. Hashmap can the key value be an object?
Ans. 
Yes, the key value in a Hashmap can be an object.
• In Java, the key in a Hashmap can be any object, not just primitive types.

• The key must override equals() and hashCode() methods for proper functioning.

• Example: HashMap employeeMap = new HashMap<>();
Answered by AI
Add your answer

Q1. Introduce you self
Add your answer
Q2. What is your project
Add your answer

Basic of General aptitude

Q1. Questions on education background
Add your answer
Q2. Engineering subjects questions like formula, calculation, units, drawing reading
Add your answer

Q1. Why should we hire you
Add your answer
Q2. Are you working in shift
Add your answer

Q1. Tell me about your projects.
Ans. 
I have worked on various projects during my engineering studies, including a solar-powered car prototype and a smart home automation system.
• Solar-powered car prototype: Designed and built a small-scale model of a car that runs on solar energy. Conducted experiments to optimize the efficiency of the solar panels and battery storage.

• Smart home automation system: Developed a system using Arduino and sensors to automate va...read more
Answered by AI
Add your answer
Q2. Have you worked with any Database.
Ans. 
Yes, I have worked with databases.
• I have experience working with SQL and NoSQL databases.

• I have worked with MySQL, MongoDB, and Oracle databases.

• I have experience in creating and managing databases, writing queries, and optimizing performance.

• I have also worked with data migration and integration between different databases.
Answered by AI
Add your answer
Q3. How to select top 10 records (using SQL) from a table?
Ans. 
How to select top 10 records (using SQL) from a table?
• Use SELECT statement with ORDER BY clause

• Add DESC keyword to sort in descending order

• Use LIMIT or FETCH FIRST clause to limit the number of records
Answered by AI
Add your answer
Q4. Can we have multiple inheritance in Java? How?
Ans. 
Yes, Java supports multiple inheritance through interfaces.
• Java does not support multiple inheritance through classes

• Interfaces can be used to achieve multiple inheritance

• A class can implement multiple interfaces

• Example: class A implements Interface1, Interface2
Answered by AI
Add your answer

Q1. Do you have any plans for higher studies?
Ans. 
Yes, I have plans for higher studies.
• I am interested in pursuing a Master's degree in Mechanical Engineering.

• I have already started researching potential universities and programs.

• I plan to specialize in the field of renewable energy.

• Higher studies will provide me with advanced knowledge and skills to excel in my career.

• I believe that continuous learning is essential for professional growth.
Answered by AI
Add your answer
Q2. Why do you want to join our company
Ans. 
I want to join your company because of its strong reputation in the industry and the opportunities for growth and development it offers.
• Strong reputation in the industry

• Opportunities for growth and development

• Alignment with company values and culture
Answered by AI
Add your answer

Q1. Basic branch related questions, example is Electronics bg: aec,ld,ckt theory
Add your answer
Q2. Interested domain and question on it
Add your answer
Q3. Personal interests ,hobbies
Add your answer