NSE.IT Interview Questions, Process, and Tips

Q1. Tell me about yourself
Ans. 
Experienced PMO Executive with a background in project management and strategic planning.
• Over 10 years of experience in leading project management offices

• Skilled in developing and implementing project management processes

• Strong background in strategic planning and resource allocation

• Proven track record of delivering projects on time and within budget

• Excellent communication and leadership skills
Answered by AI
Add your answer
Q2. Stakeholder management?
Add your answer

Q1. Question on project management ,incident management
Add your answer
Q2. How would you rate yourself in excel and basic vlookup , hlookup and data formatting question?
Add your answer

Q1. Technical round 1 was around java, microservices and your project.
Add your answer
Q2. He asked me simple java programs to check my logic programs were to check a number is palindrome or not and java streams programs
Add your answer

Q1. He asked me about project. How you used authentication in projects. Java core basics. Some tricky scenarios, solid principles and playing around oops concepts and its practical application
Add your answer

They asked 30 aptitude questions from this 30, 10 were English , 10 were quant and 10 were logical. then there were 30 question of computer skills, which consists of c++,java and python code snippets, CN, DBMS, OOPS and OS questions/

Q1. They ask completely about resume, all projects and skills mentioned in details.
Add your answer
Q2. Questions about core cse subjects, like CN, Oops.
Add your answer

Q1. They are general HR questions
Add your answer
Q2. Asked if im ready to relocate.
Add your answer

SQL coding related questions like types of joins, cursor etc

Q1. Few tricky question and advanced SQL questions
Add your answer
Q2. DDL and DML related questions
Add your answer
Q3. What are joins and their types
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL JOIN...read more
Answered by AI
Add your answer
Q4. What is cursor and their types
Ans. 
A cursor is a database object used to retrieve data from a result set one row at a time.
• Types of cursors: Forward-only, Static, Dynamic, Keyset-driven

• Forward-only cursor: Can only move forward through the result set

• Static cursor: Shows a snapshot of the data at the time the cursor was opened

• Dynamic cursor: Reflects changes made to the data while the cursor is open

• Keyset-driven cursor: Uses a unique identifier to fetch
Answered by AI
Add your answer