Aragen Life Sciences Project Executive Interview Questions and Answers

Q1. Basic topics of plsql
Add your answer
Q2. One query to fetch max n min of salary from emp table
Ans. 
Use SQL query to fetch maximum and minimum salary from emp table
• Use SELECT MAX(salary) FROM emp to fetch maximum salary

• Use SELECT MIN(salary) FROM emp to fetch minimum salary
Answered by AI
Add your answer

Q1. Performance tuning
Add your answer
Q2. Indexes and exceptions used
Ans. 
Indexes and exceptions are used to optimize database performance and handle errors in code.
• Indexes are used to quickly retrieve data from a database by creating a sorted list of values.

• Exceptions are used to handle errors in code and prevent the program from crashing.

• Examples: Creating indexes on frequently queried columns like 'id' or 'timestamp'. Using try-catch blocks to handle exceptions like divide by zero.
Answered by AI
Add your answer

Relevant to profile under discussion where the candidate is asked to produce written documents/PPTs

Q1. Tell me something about your self
Add your answer
Q2. Why you want to join us
Add your answer
Q3. Why you want to leave your current job
Add your answer

Q1. Types of clinical research
Add your answer

Q1. What is clinical research
Add your answer
Q2. Objective of clinical research
Add your answer

Q1. 1. Any innovative ideas or solution given and implemented in previous work place? What are the challenges did you faced and how did you overcome on that?
Ans. 
Yes
• Implemented a new project management software that improved team collaboration and efficiency

• Challenges faced included resistance to change and learning curve for team members

• Overcame challenges by conducting training sessions, providing ongoing support, and highlighting the benefits of the new software
Answered by AI
Add your answer
Q2. 2. How will you react when any client is very upset because of any reason?
Ans. 
I will listen to the client's concerns, empathize with them, and work towards finding a solution to their problem.
• Remain calm and composed

• Listen actively to the client's concerns

• Empathize with the client and acknowledge their feelings

• Apologize for any inconvenience caused

• Assure the client that their concerns will be addressed and a solution will be found

• Work towards finding a solution that meets the client's needs

• Follo...read more
Answered by AI
Add your answer

Q1. Education background, basic knowledge about job role, hobbies etc.
Add your answer

Q1. Another round was with US team lead, with more structured questions and explanation of work role.
Add your answer

Q1. About PM skills
Add your answer
Q2. Waterfall and agile
Add your answer