National Stock Exchange of India Associate Software Engineer Interview Questions and Answers

Q1. What are joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. What is OOP features
Ans. 
OOP features are key concepts in Object-Oriented Programming that include encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (object)

• Inheritance: Ability for a class to inherit properties and behavior from another class

• Polymorphism: Ability for objects to be treated as instances of their parent class or their own class

• Abstractio...read more
Answered by AI
Add your answer
Q3. Primary key , foreign key
Add your answer
Q4. Exception in java
Ans. 
An exception in Java is a runtime error that disrupts the normal flow of a program.
• Exceptions are objects that are thrown when an error occurs during the execution of a program.

• They can be caught and handled using try-catch blocks.

• Common types of exceptions in Java include NullPointerException, ArrayIndexOutOfBoundsException, and IOException.
Answered by AI
Add your answer

There was an aptitude test which consisted of English,Logical Reasoning and Quantitative all with 60 Questions in 60 Minutes. There were also 2 easy to medium level codes on Arrays.

Q1. First they asked to introduce yourself , then they directly started with Technical question in which they gave me 2 codes. 1.Reverse a given sentences maintaining spaces ,2. Write a code for simple calcula...read more
Add your answer

Aptitude test on engineering subjects

Writing projects in c

Q1. Snake and ladder lld
Add your answer
Q2. Spring question on annotations
Add your answer

Q1. Find k closest elements
Ans. 
Find k closest elements in an array
• Sort the array based on the absolute difference between each element and the target element

• Return the first k elements from the sorted array
Answered by AI
Add your answer
Q2. K Closest elements
Add your answer

The test carried 7 sections of aptitude with no negative markings and the questions were also easy with time duration of 1 hours which was to be used for the coding round also

Basic understanding was checked, if basics are clear of DSA and computer science fundamentals then very easy to crack

It continues for 15 mins

They asked general aptitude questions ones you can easily practice from indiabix

Be prepared with medium level DSA questions. They touched upon topics like trees, DP, hashing etc.

Q1. They had a total of two technical rounds where one was with the manager you will be working under. The touched upon some puzzles and reasoning questions. The questions will mostly be around you resume so m...read more
Add your answer

Q1. General HR questions
Add your answer