Agilysys Technologies India DOT NET Developer Interview Questions and Answers

Q1. Join in sql define and explain
Ans. 
Join in SQL is used to combine rows from two or more tables based on a related column between them.
• Join is used to retrieve data from multiple tables based on a related column

• 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

Total 50 Questions 40 from technology 10 from normal aptitude not so tough.

Q1. Telephonic interview by senior developer basic concepts of oops, sql, C#
Add your answer
Q2. Opps concepts indexes Array and arrylists Stored procedures and functions class structs object constructor etc
Add your answer
Q3. What is Encapsulation where you implement and why?
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit, known as a class.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for better control over the data by preventing direct access and manipulation from outside the class.

• Encapsulation also promotes code reusability and modularity by grouping related data and methods tog...read more
Answered by AI
Add your answer
Q4. Difference between Interfaces and abstraction?
Ans. 
Interfaces define contracts for classes to implement, while abstraction is a way to hide implementation details.
• Interfaces are like a blueprint that defines what methods a class must implement.

• Abstraction is a concept where we hide the implementation details and show only the necessary features of an object.

• Interfaces can have multiple inheritance, while abstraction is achieved using abstract classes or interfaces.

• Exam...read more
Answered by AI
Add your answer
Q5. Difference between Stored procedure and functions when we use where we use what the profits of its?
Ans. 
Stored procedures are precompiled SQL queries stored in the database, while functions are user-defined routines that return a value.
• Stored procedures are used for performing specific tasks or operations on the database, while functions are used to return a single value.

• Stored procedures can contain multiple SQL statements and can have input and output parameters, while functions are more limited in their functionality.

• ...read more
Answered by AI
Add your answer

Reverse no.
Star patterns
print numbers without loop
highest salary query
Count male female from the table

Logically question, mathematics

Q1. C#,asp.net MVC,.net core
Add your answer
Q2. SQLserver.jquery
Add your answer
Q3. Linq, store procedure
Add your answer
Q4. Logically question like how we can pass data controller
Ans. 
Data can be passed to a controller in ASP.NET using various methods like route data, query strings, and model binding.
• Use route data: Pass parameters in the URL, e.g., /controller/action/id.

• Utilize query strings: Append data to the URL, e.g., /controller/action?id=1.

• Employ model binding: Bind form data directly to action method parameters.

• Use TempData for short-lived data: Store data that needs to persist across reques...read more
Answered by AI
Add your answer

Q1. 1. oops 2. mvc lifecycle
Add your answer
Q2. 1. routing 2. filters in mvc
Ans. 
Routing and filters are important concepts in MVC development.
• Routing determines how URLs are mapped to controllers and actions.

• Filters are used to add additional logic before or after an action is executed.

• There are several types of filters, including authorization, action, and result filters.

• Filters can be applied globally, to a controller, or to an individual action.

• Routing and filters are essential for creating a w...read more
Answered by AI
Add your answer

Coding test on project based

Q1. What is timing , salary and many more
Add your answer
Q2. What is timing , salary and Many more
Add your answer

Math reasiong coding c#

Q1. Asp.netcore, SQL server web API
Add your answer

Coding,asp.net.reasiong , math

SQL server,asp
Net ,jQuery , javascript etc

Q1. Logical thinking ,practical confidence
Add your answer

Q1. Sellery discussion, privious company work details.
Add your answer