Airdit Software Services Senior Software Engineer Interview Questions and Answers for Experienced

Asked some medium level SQL questions

Q1. Everything that the HR asks
Add your answer

Discussion on experience and current role and responsibilities

Q1. 1. Discuss one past project
Add your answer
Q2. 2. Design a job scheduler
Ans. 
A job scheduler is a software application that manages the scheduling of tasks or jobs to be executed by a computer system.
• Define the job scheduling requirements such as priority, deadline, resource constraints, etc.

• Implement a scheduling algorithm like First Come First Serve, Shortest Job First, Round Robin, etc.

• Maintain a queue of jobs to be executed and allocate resources accordingly.

• Monitor job execution and handle...read more
Answered by AI
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

Q1. Discussion about the current role, tech - stack I am working upon. Problems that solved during the job. Challenges faced in current job. Expectations from the new Employer. Reason for switching the job. I...read more
Add your answer

Q1. Given coding question for cracking this your mathematical concept should be very strong. Core java questions, React questions, Javascript questions ad other DS algo basic questions.
Add your answer

Q1. JS Core concepts Java core concepts Basic DS algo hashmap question , two sum array, duplicate number SQL Question
Add your answer

Q1. Basic salary discussion round
Add your answer

Aptitude test and coding test

Q1. Python basics and about academic project
Add your answer

Q1. Python questions and hands on coding
Add your answer