Ivory Hospital Interview Questions and Answers

An aptitude test is an examination designed to assess an individual's skills or potential for success in a specific activity. These tests operate on the assumption that individuals possess inherent strengths and weaknesses, as well as a natural disposition toward success or failure in particular domains.

A group discussion (GD) is a teamwork activity where a group of people discuss a topic together.

An assignment is a task or piece of work that you are given to do, especially as part of your job or studies. The assessment for the course involves written assignments and practical tests.

Round 1 was aptitude round, it consisted of java and c++ snippets and we had to guess the output. Apart from that there were problems on speed, velocity, distance and time. Problems on word-letter patterns were also asked. The aptitude round had 30 questions and time given was 30 minutes.

Aptitude round was the only elimination round. The next following 4 rounds were non-elimination rounds. Coding test included 3 questions - 1 and half hour was given to solve the same. It is fine if you don't perform well here, since it is a non-elimination round. But try to solve 1 and half or 2 questions atleast. The questions were mainly based on 1d arrays, 2D arrays, strings and string arrays.

Q1. Introduce yourself.
Ans. 
I am a recent graduate with a degree in engineering, eager to learn and grow in the field.
• Recent graduate with a degree in engineering

• Passionate about learning and growing in the field

• Eager to apply theoretical knowledge to practical projects
Answered by AI
Add your answer
Q2. Difference between Structure and object oriented languages
Ans. 
Structure languages focus on procedures and functions, while object-oriented languages focus on objects and classes.
• Structure languages use functions and procedures to manipulate data

• Object-oriented languages use objects and classes to encapsulate data and behavior

• Structure languages are more procedural in nature, while object-oriented languages are more modular and reusable

• Examples of structure languages include C and...read more
Answered by AI
Add your answer
Q3. Explain of OOPS concepts and their real life examples.
Ans. 
OOPS concepts are fundamental to object-oriented programming and include inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance: A child class inherits properties and behaviors from a parent class. Example: Animal class can be a parent class with child classes like Dog and Cat inheriting its attributes.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: A car ob...read more
Answered by AI
Add your answer
Q4. What is static keyword and it's usage.
Ans. 
The static keyword in programming is used to declare variables, functions, or classes that retain their values or state throughout the program's execution.
• Static variables retain their values between function calls

• Static functions can only be accessed within the same file

• Static classes cannot be instantiated and have limited visibility

• Static keyword can also be used in C++ to declare class members shared among all inst
Answered by AI
Add your answer
Q5. System architecture diagram for web application project.
Ans. 
The system architecture diagram for a web application project visually represents the components and their interactions.
• Include components like client-side interface, server-side application, database, and external services

• Show how these components communicate with each other

• Consider scalability, security, and performance in the design

• Use standard symbols and notations for clarity
Answered by AI
Add your answer
Q6. Access Modifiers in java
Ans. 
Access modifiers in Java control the visibility of classes, methods, and variables.
• There are four types of access modifiers in Java: public, private, protected, and default.

• Public: accessible from any other class.

• Private: only accessible within the same class.

• Protected: accessible within the same package and subclasses.

• Default: accessible only within the same package.

• Example: public class MyClass { private int myVar; p
Answered by AI
Add your answer
Q7. What OOPS concepts are implemented in my project
Ans. 
Encapsulation, Inheritance, Polymorphism, Abstraction
• Encapsulation: Data hiding and bundling of data with methods. Example: Using private variables and public methods.

• Inheritance: Reusing code and creating a hierarchy of classes. Example: Subclass inheriting properties and methods from a superclass.

• Polymorphism: Ability to present the same interface for different data types. Example: Method overloading and overriding.

• A...read more
Answered by AI
Add your answer
Q8. DBMS core concepts
Add your answer
Q9. Overloading and Overriding
Add your answer
Q10. Approach to the coding questions asked in coding round.
Add your answer
Q11. Questions on what is cloud and what are some cloud platforms you know?
Add your answer

A project is assigned to a group of students and we need to come up with an idea on how to implement that project as a team.

Q1. Introduce yourself
Ans. 
I am a recent graduate with a degree in engineering, eager to learn and grow in the field.
• Recent graduate with a degree in engineering

• Passionate about learning and growing in the field

• Eager to apply theoretical knowledge to practical projects
Answered by AI
Add your answer
Q2. Family background
Add your answer

Q1. What do you know about acid-base balance?
Add your answer
Q2. What do you know about the 12-lead ECG?
Add your answer

Q1. Please share the 3 orthopedic surgeons name.
Add your answer
Q2. What is your work speciality.
Add your answer
Q3. Why you want join the HCL HEALTH CARE.
Add your answer

Q1. Do you know about computer based practice.
Add your answer
Q2. Aye you using any biomedical equipment please share the name and his use?
Add your answer

Q1. Salary will not be fixed properly
Add your answer
Q2. If we leave in between no experience letter will be shared
Add your answer

Q1. Short intro. All document & mentioned data on resume should be same
Add your answer
Q2. Salary negotiation
Add your answer

Q1. Discussion about the role of position
Add your answer
Q2. Sap knowledge Excel is must
Add your answer
Q3. Communication skills
Add your answer

Q1. Salary negotiation
Add your answer

Q1. About human body and their function
Add your answer
Q2. Tell me about your district in about 250 word frequently in englsih
Add your answer

Q1. About your study
Add your answer
Q2. What is sales and marketing
Add your answer
Q3. What is the role of marketing executive
Add your answer

Q1. Tell about yourself
Add your answer
Q2. Please summarize your experience with analytical or programming tools (e.g. Excel, Python, R, SQL, etc) (1 min 30 s)
Ans. 
I have extensive experience with Excel, Python, R, and SQL for data analysis and programming tasks.
• Proficient in Excel for data manipulation, analysis, and visualization

• Skilled in Python for data cleaning, statistical analysis, and machine learning

• Familiar with R for statistical modeling and data visualization

• Experience with SQL for querying databases and extracting insights
Answered by AI
Add your answer
Q3. Describe your experience in working in a cusomer support/service or client-facing role (1 min)
Add your answer
Q4. Why should we hire you (1 min)
Add your answer

Q1. Is sql necessary for your project ?
Ans. 
SQL is necessary for most projects involving databases to manage and query data efficiently.
• SQL is essential for creating, updating, and querying databases in most projects.

• Without SQL, it would be challenging to interact with databases and retrieve specific data.

• Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE.

• SQL can help optimize database performance and ensure data integrity.
Answered by AI
Add your answer
Q2. What is Hql ?
Ans. 
HQL stands for Hibernate Query Language, a query language similar to SQL but used for Hibernate ORM framework.
• HQL is used to perform database operations in Hibernate ORM framework.

• It is similar to SQL but operates on Hibernate objects instead of database tables.

• HQL queries are written in Hibernate-specific syntax.

• Example: 'FROM Employee e WHERE e.department = :dept'

• HQL queries are translated into SQL queries by Hiberna
Answered by AI
Add your answer
Q3. What are views ?
Ans. 
Views in Java are user interface components that display data from a model in a specific format.
• Views are used to represent the user interface in Java applications.

• They display data from a model in a visually appealing format.

• Examples include buttons, text fields, labels, and checkboxes.
Answered by AI
Add your answer
Q4. What are cross joins ?
Ans. 
Cross joins are a type of join operation in SQL that combines each row from one table with each row from another table.
• Cross joins do not have a join condition specified, resulting in a Cartesian product of the two tables.

• They can be used when you want to combine every row from one table with every row from another table.

• Cross joins can lead to a large result set if the tables being joined have many rows.
Answered by AI
Add your answer
Q5. Difference between delete and truncate
Ans. 
Delete removes rows one by one, while truncate removes all rows at once.
• Delete is a DML command, while truncate is a DDL command.

• Delete can be rolled back, while truncate cannot be rolled back.

• Delete fires triggers, while truncate does not fire triggers.

• Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.
Answered by AI
Add your answer