National Environmental Engineering Research Institute Project Associate 1 Interview Questions and Answers

Q1. General information
Add your answer

Q1. ECTD, EU Procedures
Add your answer

Q1. Salary Negotiation
Add your answer

Q1. Anagram of two strings in java
Ans. 
Java program to check if two strings are anagrams
• Create a function that takes two strings as input

• Convert both strings to character arrays and sort them

• Check if the sorted arrays are equal to determine if they are anagrams
Answered by AI
Add your answer
Q2. Insert and select query in MySQL
Ans. 
Insert and select data in MySQL using SQL queries
• Use INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...); to insert data

• Use SELECT * FROM table_name; to select all data from a table

• Use SELECT column1, column2 FROM table_name WHERE condition; to select specific data based on a condition
Answered by AI
Add your answer
Q3. Get and Post APIs in rest
Ans. 
GET and POST are HTTP methods used in REST APIs for retrieving and sending data.
• GET method is used to retrieve data from a server

• POST method is used to send data to a server

• GET requests are idempotent, while POST requests are not

• GET requests should only be used for retrieving data, not for modifying data

• Example: GET request to retrieve a list of users - GET /users

• Example: POST request to create a new user - POST /users
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. 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

Complexity level - moderate. Basic concepts.

Q1. Questions to assess how independently a candidate can work.
Add your answer
Q2. - Can you work independently? - Can you work under pressure in a dynamic environment?
Ans. 
Yes, I have experience working independently and thrive in dynamic environments.
• I have successfully completed multiple projects on my own, demonstrating my ability to work independently.

• I am comfortable making decisions and solving problems without constant supervision.

• I have experience working in fast-paced environments where I had to adapt quickly to changing priorities and deadlines.
Answered by AI
Add your answer

Q1. Self and other tools
Add your answer
Q2. Jenkins Linux Ansible git AWS
Add your answer