UPMC Interview Questions and Answers

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.
Add your answer
Q2. Difference between Structure and object oriented languages
Add your answer
Q3. Explain of OOPS concepts and their real life examples.
Add your answer
Q4. What is static keyword and it's usage.
Add your answer
Q5. System architecture diagram for web application project.
Add your answer
Q6. Access Modifiers in java
Add your answer
Q7. What OOPS concepts are implemented in my project
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
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. Self introduction
Add your answer
Q2. Question from my resume, medical device classification , medical standards, risk management
Add your answer
Q3. DFMEA, FMEA
Add your answer
Q4. GD&T processes
Add your answer
Q5. Exposure on cad software tools
Add your answer
Q6. Sustenance, product knowledge, mechanical fundamental, medical industry fundamental
Add your answer

Q1. Introduce yourself. Roles and Projects you were part of.
Add your answer
Q2. SQL joins, CTEs, Snowflake
Add your answer
Q3. Python libraries, data cleaning techniques
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

I have a Group discussion on online classes during Covid Advantage and disadvantage as i was in the disadvantage group I shared different views .it was about 15 min discussion

Q1. Explain Your self in brief
Ans. 
Experienced facilitator with strong communication and leadership skills.
• Over 5 years of experience facilitating workshops and meetings

• Skilled in creating engaging and interactive learning experiences

• Strong ability to manage group dynamics and foster collaboration

• Excellent communication and interpersonal skills

• Proven track record of successfully guiding groups towards achieving their goals
Answered by AI
Add your answer
Q2. Give Session to small Student on any topic
Add your answer
Q3. What Do You expect from us
Ans. 
I expect clear communication, support, and opportunities for growth.
• Clear communication regarding expectations and goals

• Support in terms of resources, training, and feedback

• Opportunities for growth and development within the role
Answered by AI
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

Q1. Person should have excellent knowledge about the document.
Add your answer
Q2. Identify the documents and send them to the concerned department for review and information.
Add your answer