AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
National Environmental Engineering Research Institute Project Associate 1 Interview Questions and Answers
National Environmental Engineering Research Institute Project Associate 1 Interview Experiences
1 interview found
Anonymous
I applied via Company Website and was interviewed in Sep 2023. There was 1 interview round.
(4 Questions)
- Q1. What are the three things that is important while writing research paper?
- Ans.
Three important things while writing a research paper
Thorough research and analysis of the topic
Clear and concise writing with proper structure and organization
Proper citation and referencing of sources to avoid plagiarism
- Q2. What is H index
- Ans.
H index is a metric that measures both the productivity and impact of a researcher's work.
H index is calculated based on the number of citations that a researcher's publications have received.
A researcher has an H index of h if h of their Np papers have at least h citations each.
H index is useful in evaluating the quality and significance of a researcher's contributions to their field.
Higher H index indicates a greater...
- Q3. Which are the international journals
- Q4. Name three scientists from international journals
- Ans.
Three scientists from international journals are Marie Curie, Albert Einstein, and Stephen Hawking.
Marie Curie - known for her research on radioactivity and the discovery of polonium and radium
Albert Einstein - famous for his theory of relativity and contributions to quantum mechanics
Stephen Hawking - known for his work on black holes and theoretical physics
Interview Preparation Tips
- Journal
- dessertation
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed before Feb 2020. There were 5 interview rounds.
Interview Questionnaire
8 Questions
- Q1. Tell me about yourself
- Q2. Interest in job role
- Q3. Previous work experience if any
- Q4. Hobbies,interests, project details
- Q5. Family background
- Q6. Why should we hire you
- Q7. How much salary you are expecting
- Q8. Any questions you can ask
Interview Preparation Tips
Selected
I applied via Walk-in and was interviewed in Aug 2023. There were 4 interview rounds.
(1 Question)
- Q1. Basic chemistry
(1 Question)
- Q1. General discussion
(1 Question)
- Q1. Chemistry nmr, reaction n mechanism
Interview Preparation Tips
Calculation and Logics
(1 Question)
- Q1. Programming and problem solving
Selected
I applied via Campus Placement and was interviewed before Oct 2022. There were 3 interview rounds.
It was an aptitude test
(2 Questions)
- Q1. It was technical test
- Q2. Sort an array with numbers
- Ans.
Use a sorting algorithm like quicksort or mergesort to rearrange the numbers in ascending or descending order.
Implement a sorting algorithm like quicksort, mergesort, or bubblesort to rearrange the numbers in the array.
Ensure the algorithm is efficient and handles edge cases like empty arrays or arrays with duplicate numbers.
Test the sorting function with different arrays to verify its correctness.
Example: [5, 2, 9, 1,
Interview Preparation Tips
- DSA
- Aml
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Mar 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Singleton in java code. multithreading, spring boot questions.
- Q2. SQL queries for finding highest salary
- Ans.
SQL queries to find highest salary
Use the MAX() function to find the highest salary
Combine with the SELECT statement to retrieve the corresponding employee details
Use the ORDER BY clause to sort the results in descending order
Use the LIMIT clause to limit the number of results returned
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
7 Questions
- Q1. Asked basic questions of sql server & ssis
- Q2. What are views and will the alter command on table changes anything in views created? Will the values change in views, if the table values changes?
- Ans.
Alter command on table affects views created on the table.
Views are virtual tables created from one or more tables.
Alter command on a table can change the structure of the table, which can affect the views created on it.
If the columns used in the view are altered or dropped, the view will become invalid.
If the data in the table is changed, the data in the view will also change accordingly.
- Q3. What are the data transformations in ssis? What is lookup?
- Ans.
Data transformations in SSIS include Lookup which retrieves data from a source based on a matching condition.
Lookup is used to retrieve data from a source based on a matching condition
It can be used to perform joins between two data sources
Lookup can be used to update or insert data into a destination based on a match
Other data transformations in SSIS include sorting, aggregating, and merging data
- Q4. Difference between drop, truncate & delete?
- Ans.
Drop deletes the table structure and data, truncate deletes only data, and delete deletes specific rows.
Drop: removes the table and all its data permanently
Truncate: removes all data from the table but keeps the structure
Delete: removes specific rows from the table based on a condition
Drop and truncate cannot be rolled back, but delete can be
Drop and truncate reset the identity of the table, but delete does not
- Q5. When identity property is inserted in the table. Will the truncate or delete change the identity value? If it changes what will be the value?
- Ans.
Truncate resets identity value, delete does not.
Truncate resets the identity value to the original seed value
Delete does not change the identity value
Example: Truncate table resets identity value to 1
Example: Delete from table does not change identity value
- Q6. What are joins and name the types? Why is self join useful?
- Ans.
Joins are used to combine data from two or more tables based on a related column. Types include inner, outer, left, right, and cross join.
Inner join returns only the matching rows from both tables.
Outer join returns all rows from both tables, with null values for non-matching rows.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and m...
- Q7. Write a query using self join to join the employees who are all managers using id in the table.
- Ans.
Query to join employees who are all managers using id in the table.
Use self join to join the table on manager id and employee id
Filter the result to only include employees who are also managers
Example: SELECT e1.name, e2.name FROM employees e1 JOIN employees e2 ON e1.id = e2.manager_id WHERE e2.manager_id IS NOT NULL
Ensure that the table has a manager_id column
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. Self and other tools
- Q2. Jenkins Linux Ansible git AWS
Complexity level - moderate. Basic concepts.
(2 Questions)
- Q1. Questions to assess how independently a candidate can work.
- 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.
(3 Questions)
- Q1. SQL interview question
- 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
- Q3. SQL query flow and window function they will ask
Interview Preparation Tips
National Environmental Engineering Research Institute Interview FAQs
Tell us how to improve this page.
National Environmental Engineering Research Institute Interviews By Designations
- National Environmental Engineering Research Institute Project Assistant Interview Questions
- National Environmental Engineering Research Institute Project Associate Interview Questions
- National Environmental Engineering Research Institute Project Trainee Interview Questions
- National Environmental Engineering Research Institute Project Assistant II Interview Questions
- National Environmental Engineering Research Institute Project Assistant III Interview Questions
- National Environmental Engineering Research Institute Project Associate 1 Interview Questions
Interview Questions for Popular Designations
- Project Manager Interview Questions
- Project Engineer Interview Questions
- Project Coordinator Interview Questions
- Project Lead Interview Questions
- Project Associate Interview Questions
- Senior Project Manager Interview Questions
- Senior Project Engineer Interview Questions
- Assistant Project Manager Interview Questions
- Show more
National Environmental Engineering Research Institute Project Associate 1 Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
National Environmental Engineering Research Institute Project Associate 1 Reviews and Ratings
based on 5 reviews
Rating in categories
|
Project Associate
85
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Project Assistant
62
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Project Assistant II
34
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Project Associate 1
30
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Project Associate 2
23
salaries
| ₹0 L/yr - ₹0 L/yr |
Central Pollution Control Board
The Energy and Resources Institute
Indian Institute of Tropical Meteorology
Centre for Science and Environment
- Home >
- Interviews >
- National Environmental Engineering Research Institute Interview Questions >
- National Environmental Engineering Research Institute Project Associate 1 Interview Questions
