Sir Ganga Ram Hospital Interview Questions and Answers for Experienced

Q1. Dotnet, angular , azure
Add your answer

Q1. 1. Basic query questions was asked including concepts such as row number logic, update, delete etc. 2. What is materialized view in snowflake?
Add your answer
Q2. 1. What is database and schema in sql? 2. What is integration runtime in Azure Data Factory?
Ans. 
1. Database is a collection of organized data, schema defines the structure of the database. 2. Integration Runtime in Azure Data Factory is a compute infrastructure used to move data.
• Database is a collection of tables, indexes, views, and other objects that store and organize data.

• Schema defines the structure of the database, including tables, columns, relationships, and constraints.

• Integration Runtime in Azure Data F...read more
Answered by AI
Add your answer

Simple and easy basic aptitude

Simple question solved in python

Q1. Program to print Prime number
Ans. 
Program to print Prime number
• Iterate through numbers and check if each number is prime

• Use a nested loop to check for factors of the number

• A prime number is a number that is only divisible by 1 and itself
Answered by AI
Add your answer
Q2. Program to compute permutations and combinations
Ans. 
Program to compute permutations and combinations
• Use recursion to generate all possible permutations and combinations

• For permutations, swap elements in the array and recursively call the function

• For combinations, include or exclude elements in the array and recursively call the function

• Use a loop to iterate through the array and generate all possible permutations and combinations
Answered by AI
Add your answer
Q3. Program to find the missing element in a series of number
Ans. 
Program to find the missing element in a series of numbers
• Iterate through the array and calculate the sum of all elements

• Calculate the sum of the series using the formula n*(n+1)/2 where n is the length of the series

• Subtract the sum of the array from the sum of the series to find the missing element
Answered by AI
Add your answer

Q1. As it was WFH, they checked for internet connection and location.
Add your answer

Q1. Most questions on e/n and coding updates and changes . MDM table
Add your answer

Q1. How to work on medicare/medicaid?
Add your answer

Q1. Questions related to NODEJS , PHP, Past projects, Resume
Add your answer
Q2. Why Mongodb over Sql
Ans. 
MongoDB is preferred over SQL for its flexibility, scalability, and ease of use in handling unstructured data.
• MongoDB is a NoSQL database, making it easier to work with unstructured data compared to SQL.

• MongoDB is schema-less, allowing for more flexibility in data modeling and changes.

• MongoDB is horizontally scalable, making it easier to handle large amounts of data and high traffic loads.

• MongoDB's document-based data ...read more
Answered by AI
Add your answer

C,c++ questions and two coding questions. basic mcq

Q1. Treeset, hashset difference
Ans. 
TreeSet and HashSet are both implementations of the Set interface in Java, but they have some key differences.
• TreeSet is a sorted set that maintains elements in ascending order, while HashSet does not guarantee any specific order.

• TreeSet uses a Red-Black tree data structure for storage, which allows for efficient retrieval of elements in sorted order.

• HashSet uses a hash table for storage, which provides constant-time p...read more
Answered by AI
Add your answer
Q2. Oops concept, dbms, programming questions
Add your answer
Q3. Set and treeset and hashset
Add your answer