Nihilent Software Engineer Interview Questions, Process, and Tips

Q1. DELETE DUPLICATES IN A QUERY AND FIND THIRD HIGHEST SALARY
Ans. 
Delete duplicates in a query and find third highest salary.
• Use the DISTINCT keyword in the query to eliminate duplicates.

• Order the salaries in descending order and use the LIMIT clause to get the third highest salary.
Answered by AI
Add your answer

Technical aptitude test. Like sql query and logical reasoning general aptitude

Q1. What is scanf, what is printf, difference between this,what is pointer,what is normalization
Ans. 
scanf and printf are functions used for input and output in C programming language. Pointers are variables that store memory addresses.
• scanf is used to read input from the user, while printf is used to display output to the user

• scanf and printf are part of the standard input/output library in C

• Pointers are used to store memory addresses of variables or functions

• Normalization is the process of organizing data in a datab...read more
Answered by AI
Add your answer

Q1. It was very difficult...many questions ask like Java python c html css
Add your answer

Q1. .Net Core, C# SQL, Web API
Add your answer
Q2. SQL server, LINQ
Add your answer

Q1. What are OOPS Concepts
Ans. 
OOPS Concepts are the fundamental principles of Object-Oriented Programming, including Inheritance, Encapsulation, Polymorphism, and Abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex i...read more
Answered by AI
Add your answer
Q2. Why is interface introduced in java
Ans. 
Interfaces are introduced in Java to achieve abstraction, multiple inheritance, and loose coupling.
• Interfaces allow for abstraction by defining a set of methods that a class must implement.

• Interfaces support multiple inheritance by allowing a class to implement multiple interfaces.

• Interfaces promote loose coupling by enabling classes to interact with each other through interfaces rather than concrete implementations.
Answered by AI
Add your answer