Application Support Engineer

1) Purpose ref keyword is used when a called method has to update the passed parameter. out keyword is used when a called method has to update multiple parameter passed.
2) Direction ref keyword is used to pass data in bi-directional way. out keyword is used to get data in uni-directional way.
3) Initialization Before passing a variable as ref, it is required to be initialized otherwise compiler will throw error. No need to initialize variable if out keyword is used.
4) Initialization In called method, it is not required to initialize the parameter passed as ref. In called method, it is required to initialize the parameter passed as out.

The abstract keyword is used to achieve abstraction in Java. It is a non-access modifier which is used to create abstract class and method. The role of an abstract class is to contain abstract methods. However, it may also contain non-abstract methods. The method which is declared with abstract keyword and doesn't have any implementation is known as an abstract method

A C++ virtual function is a member function in the base class that you redefine in a derived class. It is declared using the virtual keyword. It is used to tell the compiler to perform dynamic linkage or late binding on the function. A 'virtual' is a keyword preceding the normal declaration of a function. When the function is made virtual, C++ determines which function is to be invoked at the runtime based on the type of the object pointed by the base class pointer.

ASP.NET MVC Filter is a custom class where you can write custom logic to execute before or after an action method executes. Filters can be applied to an action method or controller in a declarative or programmatic way. Declarative means by applying a filter attribute to an action method or controller class and programmatic means by implementing a corresponding interface.
Types of filters : 
Authentication IAuthenticationFilter These are Runs, before any other filters or the action method.
Authorization IAuthorizationFilter These Runs first, before any other filters or the action method.
Action IActionFilter These Runs before and after the action method.
Result IResultFilter Runs before and after the action result are executed.
Exception IExceptionFilter Runs only if another filter, the action method, or the action resultthrows an exception.

jQuery selectors allow you to select and manipulate HTML element(s). jQuery selectors are used to "find" (or select) HTML elements based on their name, id, classes, types, attributes, values of attributes and much more. It's based on the existing CSS Selectors, and in addition, it has some own custom selectors.
All selectors in jQuery start with the dollar sign and parentheses: $().

The function must return a value but in Stored Procedure it is optional. Even a procedure can return zero or n values.
Functions can have only input parameters for it whereas Procedures can have input or output parameters.
Functions can be called from Procedure whereas Procedures cannot be called from a Function.
The procedure allows SELECT as well as DML(INSERT/UPDATE/DELETE) statement in it whereas Function allows only SELECT statement in it.
Procedures cannot be utilized in a SELECT statement whereas Function can be embedded in a SELECT statement.
Stored Procedures cannot be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section whereas Function can be.
Functions that return tables can be treated as another rowset. This can be used in JOINs with other tables.

The simplest guidance is do not create the stored procedure with prefix "sp_". I prefer to create the procedures with a convention like .
Include the SET NOCOUNT ON statement as the first statement of the procedure.
Do not write "Select count(*) from Table" statement to get the count of the records. Alternatively, use "Select count (PrimaryKeyColumn) from Table".
Try to avoid dynamic SQL queries as much as possible.
Prefer to have the table variables instead of temp tables. Keep minimal use of temp tables.
Avoid the use of the cursors to loop through the records. Instead keep the records in the table variable or temp tables.
Use schema name with an object name.
Prefer table joins over the use of subqueries in the where conditions.

TOP keyword can be used to find the nth highest salary. By default ORDER BY clause print rows in ascending order, since we need the highest salary at the top, we have used ORDER BY DESC, which will display salaries in descending order. Again DISTINCT is used to remove duplicates. The outer query will then pick the topmost salary, which would be your Nth highest salary.

SQL query : 

SELECT TOP 1 salary
FROM ( 
SELECT DISTINCT TOP N salary
FROM #Employee 
ORDER BY salary DESC 
) AS temp
ORDER BY salary

ViewData:
ViewData is a dictionary type public ViewDataDictionary ViewData { get; set; }
It can be used to pass data from controller to view, one way only
It’s life lies only during the current request
If passing string then no need to typecast
If passing object then you need to typecast it but before that you need to check if it is not null
Its a property on ControllerBase, which is the parent of Controller class

TempData:
TempData internally use TempDataDictionary: public TempDataDictionary TempData { get; set; }
Once data is saved into TempDataDictionary object:
It persists in it and can be read from any view or any action in any controller
It can only be read once; once read, it becomes null
It is saved into session so on expiration of session data is lost.

Tip 1 : The cross questioning can go intense some time, think before you speak.

Tip 2 : Be open minded and answer whatever you are thinking, in these rounds I feel it is important to have opinion.

Tip 3 : Context of questions can be switched, pay attention to the details. It is okay to ask questions in these round, like what are the projects currently the company is investing, which team you are mentoring. How all is the work environment etc.