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

Q1. About your self
Add your answer
Q2. Salary expected and your role in past company
Ans. 
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
Answered by AI
Add your answer

Q1. Types of joining
Ans. 
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
Answered by AI
Add your answer
Q2. What is use of indexing
Ans. 
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
Answered by AI
Add your answer
Q3. Use of Pivot table
Ans. 
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
Answered by AI
Add your answer
Q4. Use of store procedure
Ans. 
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
Answered by AI
Add your answer
Q5. Matrix use in ssrs
Ans. 
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
Answered by AI
Add your answer
Q6. His flow from admission to discharge
Add your answer

Q1. Antihypertensive drug?
Add your answer
Q2. Doses of paracetamol?
Add your answer

Q1. What is sterilization
Add your answer
Q2. What is patient right
Add your answer

What is sterilization

To do things well and work properly and maintain things around you well