National Environmental Engineering Research Institute Project Trainee Interview Questions and Answers

Q1. Explain yourself
Ans. 
I am a dedicated and experienced consultant with a strong background in problem-solving and client management.
• Over 5 years of experience in consulting roles

• Skilled in analyzing data and providing strategic recommendations

• Excellent communication and interpersonal skills

• Proven track record of successfully managing client relationships

• Strong ability to work under pressure and meet deadlines
Answered by AI
Add your answer

Q1. Basic chemistry
Add your answer

Q1. General discussion
Add your answer

Q1. Chemistry nmr, reaction n mechanism
Add your answer

Q1. Basic topics of plsql
Add your answer
Q2. One query to fetch max n min of salary from emp table
Ans. 
Use SQL query to fetch maximum and minimum salary from emp table
• Use SELECT MAX(salary) FROM emp to fetch maximum salary

• Use SELECT MIN(salary) FROM emp to fetch minimum salary
Answered by AI
Add your answer

Q1. Performance tuning
Add your answer
Q2. Indexes and exceptions used
Ans. 
Indexes and exceptions are used to optimize database performance and handle errors in code.
• Indexes are used to quickly retrieve data from a database by creating a sorted list of values.

• Exceptions are used to handle errors in code and prevent the program from crashing.

• Examples: Creating indexes on frequently queried columns like 'id' or 'timestamp'. Using try-catch blocks to handle exceptions like divide by zero.
Answered by AI
Add your answer

Q1. Where do you see yourself in 5 years?
Add your answer
Q2. What are your strengths and weaknesses?
Add your answer
Q3. Tell me about yourself.
Add your answer

Good round it was on maths analysis English

Q1. SQL interview question
Add your answer
Q2. Stored Procedure and function differences
Ans. 
Stored procedures are precompiled and stored in the database, while functions are compiled and stored in memory.
• Stored procedures are precompiled and stored in the database for reuse.

• Functions are compiled and stored in memory for faster execution.

• Stored procedures can return multiple values, while functions return a single value.

• Functions can be called from within a stored procedure, but stored procedures cannot be ca
Answered by AI
Add your answer
Q3. SQL query flow and window function they will ask
Add your answer