Medanta S.N. Superspecialty Hospital Application Support Engineer Interview Questions, Process, and Tips

I expect a competitive salary based on my experience as an Application Support Engineer in my past company.

• I have experience working as an Application Support Engineer in Company X for 3 years

• I was responsible for troubleshooting and resolving technical issues for various applications

• I collaborated with developers and end-users to ensure smooth operation of applications

Types of joining include inner join, outer join, left join, right join, and full join.

• Inner join: Returns rows when there is at least one match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full join: Ret...read more

Indexing is used to improve the performance of database queries by allowing for faster data retrieval.

• Indexing creates a data structure that allows for quick lookups of specific values in a database table.

• It helps in reducing the time taken to retrieve data from a database, especially when dealing with large datasets.

• Indexes can be created on one or more columns in a table to speed up search queries.

• Examples of indexes...read more

Pivot tables are used in Excel to summarize and analyze data from a larger table.

• Pivot tables allow you to reorganize and summarize selected columns and rows of data

• They can help in analyzing trends, patterns, and relationships in data

• You can easily create charts and graphs based on the summarized data from a pivot table

Stored procedures are precompiled SQL queries stored in the database for reuse and improved performance.

• Stored procedures can improve performance by reducing network traffic and optimizing query execution.

• They can also enhance security by controlling access to data.

• Stored procedures can be used for complex business logic and data manipulation.

• Examples include creating a stored procedure to retrieve customer information

Matrix use in SSRS allows for displaying data in a tabular format with row and column groups.

• Matrix in SSRS is used to display data in a tabular format with dynamic row and column groups.

• It is useful for creating cross-tab reports where data needs to be summarized and displayed in a grid-like structure.

• Matrix can be used to show aggregated data, such as sum, average, count, etc., based on row and column groups.

• It allow...read more