Infobell IT Solutions Junior Software Engineer Interview Questions and Answers

Basic multiple choice questions based on c# ,sql serve, pseudo code all are basics

Q1. Oops concepts,SQL query based on joins,sub query ,basic javascript
Add your answer

Q1. What are the different types of SQL joins.what is the difference between them
Ans. 
SQL joins are used to combine data from two or more tables based on a related column between them.
• Inner join returns only the matching rows from both tables

• 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 matching rows from the left table

• Full outer join returns all rows from both tables

• Cross join returns the Cartesian product of bo
Answered by AI
Add your answer
Q2. What is a stored procedure and how different is it from function
Ans. 
A stored procedure is a precompiled set of SQL statements that can be called by name, while a function returns a value.
• Stored procedures are used to perform a specific task, such as inserting or updating data in a database.

• Functions return a value, while stored procedures do not necessarily return a value.

• Stored procedures can be called from within other SQL statements, while functions cannot.

• Stored procedures can have...read more
Answered by AI
Add your answer
Q3. Explain MVC in detail
Ans. 
MVC is a software design pattern that separates an application into three interconnected components: Model, View, and Controller.
• Model represents the data and business logic of the application

• View is responsible for rendering the user interface

• Controller handles user input and updates the model and view accordingly

• MVC promotes separation of concerns and modularity

• MVC is widely used in web development frameworks like Ru
Answered by AI
Add your answer

Q1. How we can redirect to different page in MVC
Ans. 
In MVC, we can redirect to a different page using the RedirectToAction method.
• Use the RedirectToAction method in the controller action method

• Pass the action name and controller name as parameters to the method

• Optionally, pass route values as a parameter to the method

• Example: return RedirectToAction("Index", "Home");
Answered by AI
Add your answer
Q2. What is index and it's types
Ans. 
Index is a pointer to a specific element in an array or database table.
• Indexes improve query performance by reducing the number of rows that need to be scanned.

• Types of indexes include clustered, non-clustered, unique, and composite indexes.

• Clustered indexes determine the physical order of data in a table, while non-clustered indexes create a separate structure.

• Unique indexes ensure that each value in the index column ...read more
Answered by AI
Add your answer
Q3. Difference between tempdata and session in MVC
Ans. 
TempData stores data for a single request while Session stores data for multiple requests.
• TempData is used to store data temporarily for a single request.

• Session is used to store data for multiple requests.

• TempData is cleared after a single request while Session data persists until the session expires or is cleared.

• TempData is useful for passing data between actions while Session is useful for maintaining user-specific
Answered by AI
Add your answer